Migration DTS to IS
Hi, I am new commer(also intern student).I have several DTS packages on SQL Server 2000 that need to be migrated to SQL Server 2008. When I run the Package Migration Wizard on my Windows XP workstation, I get the following error after clicking "Finish": ------------------------------ 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 '{10020904-EB1C-11CF-AE6E-00AA004A34D5}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)). (Microsoft.SqlServer.DtsMigration) ADDITIONAL INFORMATION: 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 '{10020904-EB1C-11CF-AE6E-00AA004A34D5}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)). (Microsoft.SqlServer.Dts80) ------------------------------ I have installed both MS SQL Server 2000 and 2008 .Though I tried to find out solution from web, there is exact solution.I m trying to solve this error more than five days already. I m very grateful if any one help me. Pls Pls Pls help me .Thank you very much in advance. Monnferry
October 29th, 2010 6:08am

Hi I admit I am guessing - have you tried installing the DTS compatability components on the server? There is only a 2005 version - which 2008 uses. you can get it here: - the file is SQLServer2005_DTS.msi http://www.microsoft.com/downloads/en/details.aspx?FamilyID=d09c1d60-a13c-4479-9b91-9e8b9d835cdc It looks like the conversion is trying to create a DTS task within an SSIS package so it migh tneed this. Seth http://lqqsql.wordpress.com
Free Windows Admin Tool Kit Click here and download it now
October 29th, 2010 12:53pm

The following forum is more appropriate for your question: SQL Server Integration Services Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 GRAND SLAM
October 29th, 2010 3:16pm

Hi, Thank you very much for your help really. Moonferry
Free Windows Admin Tool Kit Click here and download it now
October 31st, 2010 11:23am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics