Are you just trying to run a DTS package? If so you can use SQL Agent to run
it or you can run it from a cfm page.
Shawn Regan
-----Original Message-----
From: Dan O'Keefe [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 14, 2004 6:30 AM
To: CF-Talk
Subject: DTS from SP
I have combed the archives, and then net, and I think I have found the
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]
- DTS from SP Dan O'Keefe
- RE: DTS from SP Shawn Regan
- RE: DTS from SP Shahzad.Butt
- RE: DTS from SP Daniel O'Keefe
- Re: DTS from SP Thomas Chiverton
- RE: DTS from SP Daniel O'Keefe
- RE: DTS from SP Robertson-Ravo, Neil (RX)
- RE: DTS from SP Shawn Regan
- RE: DTS from SP Robertson-Ravo, Neil (RX)
- RE: DTS from SP Daniel O'Keefe
- RE: DTS from SP Daniel O'Keefe
- RE: DTS from SP Daniel O'Keefe