DTS Error - SQL Server Forums

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

SQL Server 2005 Forums

SQL Server Administration (2005)

DTS Error

Author

Topic

california6
Starting Member

38 Posts

Posted - 2008-08-18 : 20:21:00

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

The error what it throws is as follows:

Source: ODSOLE Extended Procedure
Description: Class not registered

Cali

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-08-18 : 20:50:14

You should google your errors before posting as that's typically all that we are going to do.

Here's what I found:
http://kbalertz.com/932872/Error-message-stored-procedure-create-object-edition-Server-ODSOLE-Extended-Procedure-Class.aspx

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

california6
Starting Member

38 Posts

Posted - 2008-08-18 : 22:04:16

Thanks tkizer. will keep that tip in mind.

Now the workaround whats listed from the URL is: use a 64-bit compiler to recompile the COM DLL. How can i get this 64-bit compiler?

Cali

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-08-18 : 23:11:42

Maybe 64-bit VS?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources