"farshad" wrote:

> I would like to run a ssis package and pass the filename as the parameter to
> the package.
> This is what I have worked out so far but notice the error message:
>
> xp_cmdshell 'dtexec.exe /f
> "d:\sysappl\CEM\SSIS\Imports\Trades\CounterPartyExposureEquitiesImport.dtsx\EqRonnieHK.csv"'
>
> p.s. If I run the package manually, it runs without error.
>
> Error:
> Description: Failed to open package file
> "d:\sysappl\CEM\SSIS\Imports\Trades\CounterPartyExposureEquitiesImport.dtsx\EqRonnieHK.csv"
> due to error 0x80070003 "The system cannot find the path specified.". This
> happens when loading a package and the file cannot be opened or loaded
> correctly into the XML document. This can be the result of either providing
> an incorrect file name was specified when calling LoadPackage or the XML file
> was specified and has an incorrect format.
>
>
>
> Thanks
>