Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Error in creating a job in sql server 2005

Author  Topic 

laddu
Constraint Violating Yak Guru

332 Posts

Posted - 2008-10-02 : 20:59:56
Unable to cast COM object of type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.PackageNeutralClass' to interface type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSContainer90'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{8BDFE892-E9D8-4D23-9739-DA807BCDC2AC}' failed due to the following error: Library not registered. (Exception from HRESULT: 0x8002801D (TYPE_E_LIBNOTREGISTERED)). (Microsoft.SqlServer.ManagedDTS)

Please advice?

laddu
Constraint Violating Yak Guru

332 Posts

Posted - 2008-10-05 : 14:21:04
can anyone help me on this ?
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-10-05 : 14:50:21
Looks like you are running DTS package with activexscript (COM object) as a job. It is not supported in SSIS package.
Go to Top of Page

laddu
Constraint Violating Yak Guru

332 Posts

Posted - 2008-10-05 : 16:12:05
I am able to create a maintanance plan for backup job by starting dts.dll file through registry. But still not able to schedule the job. Getting below error
unhandled exception has occured in a component in your application. if you click continue the application will ignore this error and attempt to continue
Method not found : Bolean
MS SQL SERVER.management.sqlmgmt.jobscheduledata.updatesourceschedule{}'
Go to Top of Page
   

- Advertisement -