469,322 Members | 1,626 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,322 developers. It's quick & easy.

problem executing dts package using xp_cmdshell in querry analyzer

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.
Mar 7 '07 #1
0 2183

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Steve Duke | last post: by
3 posts views Thread by emily | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by Gurmeet2796 | last post: by
reply views Thread by mdpf | last post: by
reply views Thread by harlem98 | last post: by
reply views Thread by listenups61195 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.