DTS Error

• California

  SSCommitted

  Points: 1888

  More actions

  August 18, 2008 at 6:20 pm

  #123029

  I am running the following code on my server and some how it doesnt like it. The server is a SQL Server-2006-64 bit. Can someone please suggest?

  Code:

  DECLARE @objPackage int

  DECLARE @rc int

  Declare @hr int

  DECLARE @output varchar(255)

  DECLARE @source varchar(255)

  DECLARE @description varchar(255)

  EXEC @rc = sp_OACreate 'DTS.Package', @objPackage OUT

  IF @rc <> 0

  BEGIN

  EXEC @hr = sp_OAGetErrorInfo @objPackage, @source OUT, @description OUT

  IF @hr = 0

  BEGIN

  SELECT @output = ' Source: ' + @source

  PRINT @output

  SELECT @output = ' Description: ' + @description

  PRINT @output

  END

  RETURN

  END

• California

  SSCommitted

  Points: 1888

  More actions

  August 18, 2008 at 6:21 pm

  #859754

  Sorry the error what i get is as follows:

  Source: ODSOLE Extended Procedure

  Description: Class not registered