Not able to craete a job for bacakup

• Minto Minto(quendans)

  SSCrazy

  Points: 2533

  More actions

  October 12, 2010 at 3:12 am

  #227916

  Hi,

  For daily backup i am not able to craete a job,because when i clicked on new step to write a query i am getting one error...That is

  Unable to cast COM object of type 'Microsoft.sqlserver.Dts.Runtime.Wrapper.PackagesNeutralClass' to interface type 'Microsoft.Sqlserver.Dts.Runtime.Wrapper.IDTSContainer90'.

  This operation failed because the Query interface 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:0X8002810D(TYPE_E_LIBNOTREGISTERED)).

  (Microsost.SqlServer.ManageDTS)

  We are using sql server 2005 enterprise edittion sp2

  Kindly help me .....

• homebrew01

  SSC Guru

  Points: 55553

  More actions

  October 12, 2010 at 9:54 am

  #1235650

  Are you using BIDS ? I found this thread with 1 possible solution, not sure if it's relevant.

  http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/7f5c9ae1-ecd3-4ead-98fd-2d074720e31d

  Can you create a basic maint plan to schedule & run backups ?