DTS Packages Unspecified Error

WE have dts packages created with ftp component in Sql 2000 dts designer. At the same time client where we are developing the package has sql 2005 components. When we move this package to sql 2000 production server - we can execute nor we can open the package it will give unspecified error.

if we recreate the package on client which does not have sql 2005 component than only it works. So for any mistake the packge once opened in sql 2000 designer also with client having sql 2005 components it does not work. Only criteria this error happens when you have ftp component used in dts package.

Did anyone has seen this problem ? Any fixes or patches available to be applied ?

Thanks for the help.

Manoj

Hi

Microsoft already know this problem but dont release the hotfix, you need to contact them.

http://support.microsoft.com/kb/890841

I have the same problem and to fixe it, I recovered an old version of DTS through the server and made the modifications.

If you found a better way please contact me.

Thanks

|||

Thanks

Looks like this hotfix should resolve the issue, I will touchbase with microsoft and will try to install the hotfix.

Let you know.

Manoj

|||

I tried after applying the hotfix - it did not work.

Manoj

|||I'm having the same problem. Did you every get this fixed?|||DTS is provided for the backward compatibility in SQL 2005, you might need to rewrite the same in SSIS to provide the functionality.