info I need to be able to do this.
I used the DTSRUNUI to create this string:
'DTSRun /S "TESTDATA" /U "sa" /P "password" /N "frDay01_upload" /G
"{F96F01E6-D82C-4ECF-899E-7DDADB1976C6}" /W "0" '
When I run it from the DOS prompt, it works. When I try to run it with:
exec master..xp_cmdshell, both from QA and a SP, I get the following error:
DTSRun: Loading...
Error: -2147024629 (8007010B); Provider Error: 0 (0)
Error string: The directory name is invalid.
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 713
NULL
naturally the most frustrating part is trying to find out more info on
the error. I have looked in the mentioned .hlp file as well as MS &
google. Anybody have any ideas?
Dan
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
