Hi Guruz !
I am Using "Dtsrunui.exe" Application to generate a script for running a dts packet in our sql server . I generate command and run it with store procedure "xp_CmcShell" .. It Works Fine .
But When i run script through "xp_CmcShell" that is generated for a dts packet stored in Structured storage File , it returns error as follow :

Query I am Executing is :

xp_cmdshell 'DTSRun /N "Importazione Cobsql - CobsqlNew _Server" /G "{6AEF183F-FE19-11D6-BE8A- 0000E83C6CE2}" /F "C:\InnovaGroup\Imp.dts" /W "0" '
And Error IS :

Error: -2147287038 (80030002); Provider Error: 0 (0)
Error string: The system cannot find the file specified.

While Same Package Runs If I run it manually from "Dtsrunui.exe" Application ..
Thanks ..
Usman


MS Sql Server LazyDBA home page