> You should be able to do this using the dynamic properties task.

> Hi,
>
> You should be able to do this using the dynamic properties task.
>
> HTH,
> K
>
> ----- Uwe Müller wrote: -----
>
> Hi
>
> i have a dts-package which exports sql-data to an excel sheet, works
fine.
>
> now i want a dynamic output path, which i read from a sql-table into
a
> global value of the package (also no problem)
>
> can i assign this global value to the excel connection datasource
>
> many thanks
> uwe
> Heidelberg, Germany

> Hi Uwe,
>
> Thanks for using the newsgroup and thanks for the community memebers
> situation.
>
> As for your question of using dynamic path to export, I think there is one
> good article you could read for reference. It is written by one of our
MVP.
>
> SQL Server Data Transformation Services (DTS) Best Practices
> http://vyaskn.tripod.com/sql_server_dts_best_practices.htm
>
> Hope this helps. If you still have questions, please feel free to post
your
> message here and I am ready to help.
>
> Best regards
>
> Baisong Wei
> Microsoft Online Support
> ----------------------------------------------------
> Get Secure! - www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only. Thanks.
>