[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',
It runs fine from Query Analyzer, but from the program I get a status code of "-1 General Error"