Unable to Open DTS Packages Anymore
Hi,
I installed the dts designer component for 2005 so I could migrate over some 2000 packages and was able to successfully open and run dts packages under 2005.
Then all of a sudden I get this error msg and can't open them, migrate them, export them, etc:
"here were errors loading the package "MyPackageName":
[DNETLIB][ConnectionOpen (Invalid Instance()).] Invalid connection.
(Microsoft.SqlServer.DtsObjectExporerUI)"
That is not a typo, it actually says "here were errors..." instead of "There were errors..."
I've tried the obvious, repair the dts designer component and rebooting, no luck.
Anybody seen this?
Hope this is the right group to post to...
Thx
[767 byte] By [
R.K.S.] at [2007-12-26]
I have several problems, although not the one you had, using DTS legacy to open 2000 packages.
First, I had SQL 7, 2000 and 2005 client tools installed on my computer. If you try to open the 2000 DTS package under 2005 legacy, it displayed the error "you need dts client tools" (whatever it says) even though they say you don't need them if you already have 2000 installed. And after installing the DTS tools, get the same error. Uninstalling SQL 7 client tools fixed the problem.
Next, there are wierd things going on with the DTS legacy mode. Do this, open a query window in 2005 SMC, open a DTS legacy package in design. Now click on the query window and type, now try to backspace, delete, arrow anything. Basically, all you can do is type letter/numbers in the query window. This is a pain when I was trying to cut and paste queries from DTS to query window for testing under 2005.
I have also seen very wierd things, when I open a DTS package and use SSIS and cut and paste between windows. Sometimes it works, sometimes not. Sometimes if I just click the DTS editor window again and click back to SSIS, it will paste.
Moral of the story, I always use 2000 to view/edit 2000 DTS packages.
Tom,
I have had simliar experiences that you describe, especially the query window and not being able to backspace, etc.
Unfortunately I am migrating over 2000 packages to 2005 so I must use 2005 to manage them. Eventually we will convert to SSIS but I want to get the orginal DTS packages working first.
Also, Jamie, I opened a bug report on microsoft connect 1 month ago(for another issue) and received no response. How long would you expect to wait for someone to review it?
Thx
R.K.S. wrote: