September 10, 2004 at 3:32 am
Good day Everyone
I have successfully transferred 50 DTS from development to live/production environment successully. BUT my problem is how can I make the DTS themselves to point to the right server on the design site because they are still pointed to the developement server. I can really go to 50 of them one by one and change the design site to point to the right server. Any one with an idea of how i can do this quickly please reply!
Thanks in advance
Regards
September 10, 2004 at 4:21 am
Hi,
Could you modify your DTS packages to have a new dynamic properties task which modified the connection string using an incoming global variable. Thus when you called the DTS package from a job you could pass the username, password & server in.
This would mean your code is the same in both development & production, the only difference would be how you called it from the job scheduler.
Hope the above makes sense, let me know if you would like me to ellaborate.
Cheers
Pete
September 29, 2004 at 10:56 am
I build connections using udl files. Change the server name in the udl based on location (dev or prod) and the packages have the correct reference.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply