Change Email Task Properties

HI,

How can I programmatically change the properties of Send Mail task using Script Task. I want to change the From, To and Attachment parameters of the Send Mail task.

If the Script Task can't do it, Is there any alternative to do?

Thanks

All those questions are answered here: http://blogs.conchango.com/jamiethomson/archive/2006/06/28/4156.aspx

-Jamie

Change Default Filename with Export?

When I use URL Access to render a report with specified parameters and a
format (e.g. PDF), when I choose "Save" (instead of Open) the default
filename is listed as "ThisReportName.pdf". I need to have the "Save As"
name to be very specific (e.g. include the date and the customer ID, like
EN12345-9-27-07.pdf) and ready to save without any typing by the end-user.
I cannot find a URL parameter that will change the default filename (to be
saved) for an exported PDF. Is this possible with SSRS?
Thanks for any help or direction.On Sep 27, 12:10 pm, "Don Miller" <nos...@.nospam.com> wrote:
> When I use URL Access to render a report with specified parameters and a
> format (e.g. PDF), when I choose "Save" (instead of Open) the default
> filename is listed as "ThisReportName.pdf". I need to have the "Save As"
> name to be very specific (e.g. include the date and the customer ID, like
> EN12345-9-27-07.pdf) and ready to save without any typing by the end-user.
> I cannot find a URL parameter that will change the default filename (to be
> saved) for an exported PDF. Is this possible with SSRS?
> Thanks for any help or direction.
I believe that I answered this question in your other posting.
Regards,
Enrique Martinez
Sr. Software Consultant

Change Data Souce

How to change shared data source in dinamic mode by parameters?
If you have a sample, please send me a link.
Thanks.
Helder Flores
Sinatecno TIYou can not change the data source in SQL 2k... however you can use linked
servers, etc and create the query on the fly, which gives you the ability to
dynamically change from one server to the next ie in the data set
if @.reportparamtype=1
select * from dbo.table1
else
select * from mylinkedserver.pubs.dbo.table1
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"Helder Flores" <helderflores@.discussoes.microsoft.com> wrote in message
news:1F5F4C61-F3FE-4D6F-88CC-6D676EA9B8E6@.microsoft.com...
> How to change shared data source in dinamic mode by parameters?
> If you have a sample, please send me a link.
> Thanks.
> Helder Flores
> Sinatecno TI
>|||It's a good way to solve this problem. Thanks Wayne.
--
Helder Flores
CEO - Sinatecno TI
"Wayne Snyder" wrote:
> You can not change the data source in SQL 2k... however you can use linked
> servers, etc and create the query on the fly, which gives you the ability to
> dynamically change from one server to the next ie in the data set
> if @.reportparamtype=1
> select * from dbo.table1
> else
> select * from mylinkedserver.pubs.dbo.table1
>
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> (Please respond only to the newsgroup.)
> I support the Professional Association for SQL Server ( PASS) and it's
> community of SQL Professionals.
> "Helder Flores" <helderflores@.discussoes.microsoft.com> wrote in message
> news:1F5F4C61-F3FE-4D6F-88CC-6D676EA9B8E6@.microsoft.com...
> > How to change shared data source in dinamic mode by parameters?
> > If you have a sample, please send me a link.
> >
> > Thanks.
> >
> > Helder Flores
> > Sinatecno TI
> >
>
>