SQL Server Performance Forum – Threads Archive
Change connections of all DTS
How can I change the name of the datasource of all my connections of all my DTS packages easily? I have more than 100 DTS package and it is such a burden to change all datasources one by one. I checked in the msdb.sysdtspackages but the package data are stored as <binary>. Is there an easy way to change all my connections by a simple update in a system table? Regards Patrickthere are very limited tools available for DTS. So I think you have to do it manually.[xx(] —————————————-
http://spaces.msn.com/members/dineshasanka
Check thishttp://www.sqldts.com/default.aspx?204 link is any help to you. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
I know this link <a href=’http://www.sqldts.com/default.aspx?204′ target=’_blank’ title=’http://www.sqldts.com/default.aspx?204′<a target="_blank" href=http://www.sqldts.com/default.aspx?204>http://www.sqldts.com/default.aspx?204</a></a> that was the procedure I followed to transfer all my DTS packages from one server to the other. Unfortunatelly the DTS connections where still pointing to the source server [<img src=’/community/emoticons/emotion-6.gif’ alt=’
‘ />]
Then as Dinesh said not much help is offered, may check abouthttp://www.sqldts.com/default.aspx?205 link. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Are your data sources sql servers? If so here is a really dodgy idea which might work but I would only use as a quick fix. On your DTS server, use the SQL Server Network Client Utility to create a tcp/ip alias to your new server with the alias being your old server name. The sql client might use the alias first. I would however recommend you do the sensible thing and update your packages and maybe use dynamic properties to do this in the future.
]]>