I might need to install EM on the intranet web server so I can do it through COM. I hate to do that since I can get it to run from a DOS prompt, but cannot get it to run from QA or a SP.
Dan
-----Original Message-----
From: Shahzad.Butt [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 14, 2004 10:02 AM
To: CF-Talk
Subject: RE: DTS from SP
Just create a scheduled job (in Sql) 'JOB1' then right click on that
job, properties then click on STEPS tab. Click edit it will give you the
code to run the DTS. You can copy this DTS code and paste it under
DTSRUN
e.g
master.dbo.xp_cmdshell 'DTSRun
/~Z0x3B2318455D75B2F1BC92AF9FA5AD4F411F72662FE92795909F7E45FD2518C5A3D9A
348AD5FF91DB24B84FC23F9E36EAD2975C5143E87E99773'
Now you can run it as a query in coldfusion, SQL or save it as stored
procedure.
You can delete the job afterwards as you've created the job just to get
the DTS ID
Shaz
_____
From: Dan O'Keefe [mailto:[EMAIL PROTECTED]
Sent: 14 January 2004 14:30
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]