hi,
I need to execute DTS from OACreate Method. I got Error

Load Package Failed..

This is my code:

Declare @hr int, @oPKG int

EXEC @hr=sp_OACreate 'DTS.Package',@oPKG out
IF @hr <> 0
BEGIN
PRINT '*** Create Package object Failed'

RETURN
END

--- DTSSQLStgFlag_Default = 0

EXEC @hr=sp_OAMethod @oPKG,'LoadFromSQLServer
("Servername","Username","Password",0,,,,"Packagen ame")'
IF @hr <> 0
BEGIN
PRINT '*** Load Package failed'
RETURN
END

EXEC @hr = sp_OAMethod @oPKG, 'Execute'
IF @hr <> 0
BEGIN
PRINT '*** Execute failed'
--EXEC sp_displayoaerrorinfo @oPKG , @hr
RETURN
END


EXEC @hr=sp_OADestroy @oPKG
IF @hr <> 0
BEGIN
PRINT '*** DesTroy Package failed'

RETURN
END
What is the wrong in my code.

Thanks in advance,

Regards,
Prakash.

Have a look here

http://www.databasejournal.com/featu...le.php/1459181

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Prakash" <dharmaprakash (AT) prudencetech (DOT) com> wrote

hi,
I look at the side.

In DTS, I Need to convert the MSAccess data to sqlServer.
So Establish a Connection. Before convert I take a backup.

So, Using the OACreate method, It execute only the Query.
That is, backup which is written in query is executed.

But convertion process didn't process.

Here I am getting Load Package Failed.

So, what is the wrong?

Please help..

Thanks in advance.

With regards,
Prakash.