Hi,
I am trying to execute my dts package from sql using command shell as
exec master..xp_cmdshell 'dtsrun /Sfiutopiadb /Usa /P /NBulktest'
The package works perfectly in enterprise manager. Also works if i run the command 'dtsrun /Sfiutopiadb /Usa /P /NBulktest' in the command prompt.
but when through sql query analyzer i try using 'exec master..xp_cmdshell...." as shown above it gives the following error.
DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSDataPumpTask_1
DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005)
Error string: Failure creating file.
Error source: Microsoft JET Database Engine
Help file:
Help context: 5003436
Error Detail Records:
Error: -2147467259 (80004005); Provider Error: -329978796 (EC54EC54)
Error string: Failure creating file.
Error source: Microsoft JET Database Engine
Help file:
Help context: 5003436
DTSRun OnFinish: DTSStep_DTSDataPumpTask_1
DTSRun: Package execution complete.
NULL
Any help is appreciated.