471,852 Members | 927 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,852 software developers and data experts.

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 2270

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
NeoPa
reply views Thread by NeoPa | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.