Hi,
   this is probably been asked many times but i see it in the forum.
I need to create a DTS package that is run from a stored procedure.
Basically the package dumps data to a .CSV, and needs three parameters: start date, end date and output file Path(and file name).
I ve set up all three as global variables, and have no problem with getting the dates into the SQL statement. However I can't get the file name to change.
   I found some questions the referred to dynamics, in DTS,
   Can any one hep with this, or refer me to a good source.
Thanks
Peter

I think I just answered my own question, I should have been looking at the parameters of the connection, not the pump task, in the dynamic tasks.
     This is what happens trying to find the answers in the help rather than just playing around with the designer......
thanks
Peter

I presume you are calling or job or more likely using xp_cmdshell 'dtsrun.exe /N' to launch the package.
By passing in the Global variables to dtsrun.exe using the /A option you can overwrite the values. Then use a dynamic properties task to alter the connection object passed on the Global variable.

For more info see: http://www.mutuallybeneficial.com/in...s_portable.htm

David Lundell
Principal Consultant and Trainer
www.mutuallybeneficial.com