SSIS Com Object Error when opening "upgraded" package
-
I have a package from SQL 2005 that was upgraded to SQL 2008 and then (recently) upgraded to SQL 2012 with Data Tools. When I open the package in Data Tools, it starts validation, gets about halfway through, then sudden a whole bunch of pop up errors show up (see below).
I opened up the package because it was taking almost a day to run in our new Test environment, which told me something was wrong. Now I'm getting this error.
I've tried registering the DTS.DLL file in the 110\DTS\Binn folder (the link I found was for an older version of SQL that said to check the 90 folder, but my 90 folder doesn't have a DTS folder underneath it anymore. Probably got removed when the older SQL was uninstalled.), but that didn't work.
Any ideas on what the issue could be?
-
Brandie Tarvin (5/17/2016)
I have a package from SQL 2005 that was upgraded to SQL 2008 and then (recently) upgraded to SQL 2012 with Data Tools. When I open the package in Data Tools, it starts validation, gets about halfway through, then sudden a whole bunch of pop up errors show up (see below).I opened up the package because it was taking almost a day to run in our new Test environment, which told me something was wrong. Now I'm getting this error.
I've tried registering the DTS.DLL file in the 110\DTS\Binn folder (the link I found was for an older version of SQL that said to check the 90 folder, but my 90 folder doesn't have a DTS folder underneath it anymore. Probably got removed when the older SQL was uninstalled.), but that didn't work.
Any ideas on what the issue could be?
Yours is looking for the "100" variety, rather than the 110 that you registered or the 90 that you saw on the link. I guess that the 100\DTS\Binn is empty?
Forever trying to learn
My blog - http://www.cadavre.co.uk/
For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/ -
Haven't ran into this specifically, but have heard about it.
Ideally, you're getting the RPC_E_WRONG_THREAD call here, which means:
A RPC_E_WRONG_THREAD error occurs when a thread calls via an interface pointer which is for a proxy object that does not belong to the thread's apartment.
Edited: Good point in the post above with 100. Check that first.
-
Cadavre (5/17/2016)
Yours is looking for the "100" variety, rather than the 110 that you registered or the 90 that you saw on the link. I guess that the 100\DTS\Binn is empty?Yes. And apparently I missed the 100.
Can I just copy the 110 DTS folder into the 100 folder? Actually, though, since SQL 2008 is installed, I'm going to do a folder search. See if I can find it elsewhere.
-
YAY!
When the company pushes packages to desktops / laptops, they create a folder in which the upgrade files are kept. This allows uninstalls, fixes, etc. without having to repush stuff. I found the 100\DTS\Binn folder in one of those, copied it over to the official Program Files path, reopened the package in Data Tools and no COM object error!
Whoo hoo!
Thanks for your help, guys. I appreciate it.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply