October 9, 2008 at 10:06 am
Im trying to migrate my DTS packages to SSIS. But when I try iusing the wizard I get the following error. Any lead would be great. I cant find anything on the web.
- Control Package Daily Sales Update (Stopped)
Messages
* 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)
October 9, 2008 at 11:13 am
Please don't cross post.
http://www.sqlservercentral.com/Forums/Topic583444-391-1.aspx
October 9, 2008 at 11:16 am
SP3.
You think I should try upgrading to SP4, then try the migration?
October 9, 2008 at 11:19 am
I apoligize I did not mean to.
I tried on 2005 first then I downloaded the Free version of 2008 to try the same.
That is why I posted on both.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply