run DTS from query analyzer

[washaw]

I have posted the thread in DTS forum but couldn't get response, I know this thread doesn't belong in this forum, but I am posting this incase somebody should respond.

I have a DTS called myDTS wich has one input parameter called inputParam, I am trying to run it from query analyzer and wrote this query

EXEC @hr = sp_OACreate 'DTS.Package', @object OUTPUT
if @hr <> 0
BEGIN
    print 'error create DTS.Package'
    RETURN
END

EXEC @hr = sp_OAMethod @object, 'LoadFromSqlServer', NULL, 
  @ServerName='myServer', @PackageName='myDTS', @Flags=256
IF @hr <> 0
BEGIN
    PRINT '***  Load Package failed'
END

what is wrong with the above code and how can I excute the package with the input parameter?

Thanks

 

[AlexCuse]

thread961-1457607

[small]----signature below----[/small]
Majority rule don't work in mental institutions

My Crummy Web Page