[archive] SQL Server Stored Proc-DTS Package

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

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',

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