August 6, 2010 at 7:17 am
This has probably been answered before.. but I've googled this to death and it is still very confusing to me.
Here is my scenerio.
I have a sql server 2005 on a 32 bit platform and we run about 20 DTS packages in backward compatibility mode.. in other words, the DTS packages show up under the LEGACY tab in Management Studio and they all run fine.
Now we are migrating to a SQL Server 2005 Server on 64 bit platform.
What are the steps that need to happen to get these DTS packages migrated to and running on the new 64bit Server??
August 6, 2010 at 9:09 am
I have a sql server 2005 on a 32 bit platform and we run about 20 DTS packages in backward compatibility mode.. in other words, the DTS packages show up under the LEGACY tab in Management Studio and they all run fine.
Now we are migrating to a SQL Server 2005 Server on 64 bit platform.
What are the steps that need to happen to get these DTS packages migrated to and running on the new 64bit Server??
Are you planning to migrate DTS to SSIS? If not, i hope DTS packages would continue to run as it is in the 64 bit platform. To move the packages to the new server you can open the DTS packages in the DTS designer and save it to the destination server. Please see the below link for more details.
http://support.microsoft.com/kb/314546
[font="Arial"]BASKAR BV
http://geekswithblogs.net/baskibv/Default.aspx
In life, as in football, you won’t go far unless you know where the goalposts are.[/font]
August 6, 2010 at 9:20 am
The Server I am migrating the packages FROM and the Server that the packages are going TO are on two different and seperate Networks at two different hosting facilities. I cannot migrate Server to Server because they cannot see each other. Would you recommend scripting out the DTS packages or is there a different way to import them other than straight Server to server?
August 6, 2010 at 9:32 am
Jpotucek (8/6/2010)
The Server I am migrating the packages FROM and the Server that the packages are going TO are on two different and seperate Networks at two different hosting facilities. I cannot migrate Server to Server because they cannot see each other. Would you recommend scripting out the DTS packages or is there a different way to import them other than straight Server to server?
Can you able to connect to that server and open the dts packages? Once you open the package click "save as" and save them to a folder. You can copy these packages to a disk or so and copy it back to the new server. You need to open these packages in the new server and click "save as" and specify the new server to save it back to the Legacy folder.
[font="Arial"]BASKAR BV
http://geekswithblogs.net/baskibv/Default.aspx
In life, as in football, you won’t go far unless you know where the goalposts are.[/font]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply