Hello All, as a matter of fact , i have a complecated situation and really need your advice please. we have tested the migration from SQL 2000 to SQL 2008 and now it's time for live implemntation ... planned to migaret the DTS server the last one , so i have to make all DTS deployed there to point to the new destination (SQL 2008..)here is the problem i have around 2000 DTS and most of them using the real IP hard coded in the SP and Views and it's kind of madnees to visit all SPs and Views to make them point to the new distination my question is... is there a way to make all connections come out from that servers redirect to the new destination SQL2008 untill migarte that server as well

you have very tough time. using the wizard for migration can help you only for simple DTS packages but for the complex one you need to open the package and write/modify the code. There is no short cut... Let us TRY this | My Blog :: http://quest4gen.blogspot.com/

I'm no expert on routing and addressing, but isn't there something you can do with the Hosts file, or maybe set up a registry hack to fool the system and re-direct the target? Again, only thinking out loud, maybe somone with more experience has a suggestion? If this was SSIS, you could do a Find/Replace in the XML coding, but I don't think DTS has any viewable code.Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.

There is no design for DTS in SQL Server 2008. There is only run time which can be installed. The DTS can be called from SSIS using the DTS runtime. Check http://msdn.microsoft.com/en-us/library/bb500440.aspx. However, its a database thing to replace all the IPs point to the new SQL Server 2008.Happy to help! Thanks. Regards and good Wishes, Deepak.

There is no design for DTS in SQL Server 2008. There is only run time which can be installed. The DTS can be called from SSIS using the DTS runtime. Check http://msdn.microsoft.com/en-us/library/bb500440.aspx. However, its a database thing to replace all the IPs point to the new SQL Server 2008.Happy to help! Thanks. Regards and good Wishes, Deepak.