[archive] SQL Server Stored Proc-DTS Package

[Migrated content. Thread originally posted on 08 June 2009]

Hello
Has anyone called a SQL Server Stored Procedure that runs a DTS Package from Acucobol? The code in the Stored Proc is as follows:

EXEC master..xp_cmdshell 'dtsrun /S SQLFMMA /N DTS_BOHActionsMK /U PDI /P /L \\\\mplsfp01\\cobol\\data-lib\\logfile.txt',
no_output

It runs fine from Query Analyzer, but from the program I get a status code of "-1 General Error"

Thanks