June 14, 2011 at 7:26 am
Hi everybody,
Today I migrate the 70 DTS packages one sql server 2005 sp4 to another sql server 2005 sp4.But i am not able to migrated the dts packages.I am getting below error .
-- Unable to cast COM object of type 'System.__ComObject' to
interface type 'DTS.CUSTOMTask'.
This operation failed because the QueryInterface call on the COM
component for the interface with IID '' failed due to the following error: No such interface supported
(Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).
could any body please provide the solution
Regards
venkat
June 15, 2011 at 3:39 am
What tool you are using to migrate DTS package?
This is a tools related issue and you might try connecting to SQL instance and run migration task again.
-Satya SK Jayanty
SQL Server MVP (Follow me @sqlmaster)
Author of SQL Server 2008 R2 Administration CookBook
SQL Server Knowledge Sharing network
June 15, 2011 at 4:14 am
Satya_skj (6/15/2011)
What tool you are using to migrate DTS package?This is a tools related issue and you might try connecting to SQL instance and run migration task again.
Thanks for the reply.I did not use any other tools.I used sql server migration task and SSIS also i am facing same error.
Regards
venkat
June 16, 2011 at 7:34 am
Do yourself a huge favor and check out (disclosure: I work for Pragmatic Works) DTSxChange. It will convert packages for you automatically. It will save you TONS of time/headache. Can convert from 2000/2005 to 2008. http://pragmaticworks.com/Products/Business-Intelligence/DTSxChange/Default.aspx
=============================================================
/* Backups are worthless, Restores are priceless */
Get your learn on at SQL University!
Follow me on Twitter | Connect on LinkedIn
My blog: http://sqlchicken.com
My book: Pro Server 2008 Policy-Based Management
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply