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,

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_..._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.

have found it, see ms knowledge base 242391 : means with active script in
the package


"K" <anonymous (AT) discussions (DOT) microsoft.com> schrieb im Newsbeitrag
newsB8C9CA4-C4CA-4A54-A56F-99D5CC3D6455 (AT) microsoft (DOT) com...

thanks,

i found a link on the bottom of your article to ms knowledge base

uwe

"Baisong Wei[MSFT]" <v-baiwei (AT) online (DOT) microsoft.com> schrieb im Newsbeitrag
news:Uw3bdlD%23DHA.2100 (AT) cpmsftngxa07 (DOT) phx.gbl...