Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
 Posted - 2006-07-27 : 03:38:21
|
| Hi i've a downloader.exe file that has a link to a website which downloads a file into a directory, I've tried to use a excute process Task in a DTS package to run this but it does not work Here is the code in my bat file. downloader.exe is a application i install on mt pc its take the variables of - download and the web address also a location to copy the files to..downloader.exe -download http://xww.uxb.gbr.xerox.com/service_Analyst/Files/SBS.mdb B:\Consumables_Orders_Cost_Reports_Files\UK_SBS\SBS.mdb |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-07-27 : 04:14:34
|
| What happens when you try to run it?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
Posted - 2006-07-27 : 04:19:00
|
| The task completes ok without no errors but the program does not run, so Nothing happings. I was reading up that vb script can be written to down load files from the net, but i have never worked with vb before any idea's |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-07-27 : 04:22:39
|
| Try putting an echo hello > c:\a.txtIn the bat file to check that you are calling it.When you get that working then put the exe call back in.Do you have to do this from dts?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
Posted - 2006-07-27 : 04:35:11
|
| That works fine, it create a new file , but when i put the .exe code back it it create the file again but does not run the .exe file. I think the problem is running this file as wheni do it munually it opens a small window and starts to down load the file, when complete to then launches a win32 window.. I can schedule windows to launch the download, that works fine but it would be nice to have it in my dts, |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-07-27 : 05:18:09
|
| It's probably that window that's the problem.Do you have an ftp interface to the file?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Running a exe or bat file