Error while opening DTS package | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Error while opening DTS package

Hi, I have a DTS package which I received from a Vendor as .dts file. When I try to open the same on SQL Server 2000 (Developer Edition) Enterprise Manager, I get the following error Error Source : Microsoft Data Transformation Services (DTS) Package
Error Description : General error -2147286779(80030105) Any help is highly appreciated. Thanks

Could be a lot of reason.
Ask to your vendor about how (OS, SQL, etc.) he created.
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte
All postings are provided “AS IS” with no warranties for accuracy.
Thanks for the quick reply. I was guessing that it could be Service Pack issue.
I tried opening the DTS on Enterprise Edition with latest service pack installed. I received the same error. I am positive that the vendor has created this DTS using SQL Server 2000 version. But am not sure of the OS. It could be Windows 2000 server. Will that OS version really matters ? Thank you.
Could be service pack.
Did you check DTS permissions. I mean, vendor create DTS with witch account?
Agree about OS, I don’t think this is the problem. Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte
All postings are provided “AS IS” with no warranties for accuracy.
Hi, Checked with the Vendor. He created the DTS on Win XP and Personal Edition of SQL Server 2000. He said it is working fine with all the companies that he distributed this.
I will also find how he saved this DTS package
Hi, If the package uses a special task created by the vendor, this task should be registered in your computer otherwise you could receive a error. Ask to the vendor if there is any special setup of its dts package.
]]>