DTS Migration Error
Posted on 2006-03-29
I'm facing Weird kind of DTS Migration Error.
I've created a set of DTS Packages on MS SQL Server 2000, SP4 on Windows 2003, SP1. When this is executed via the GUI Console or via the DTSRun.exe utility it works fine.
But if copy this DTS Packages to other Windows 2003 server running the same version of SQL Server(with patches), it fails to open the DTS package [It gives Unknown error]. On trying to execute using the DTSRun utility it gives Unknown error (Error Code : 80004005).
But if I copy the same package to any other machine running Windows 2000 Server SP4 and SQL Server same version, it does not create any problem and runs fine.
All the packages are created and saved as structured file system object, so that this can be easily migrated from machine to machine.
Please help ASAP.
Thanx in advance.