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 |
|
Vivaldi
Constraint Violating Yak Guru
298 Posts |
 Posted - 2003-06-20 : 11:14:40
|
| I have around 40 files coming in to an ftp server.On the internal network, i have a sql server that runs a job that grabs the files from the ftp server every 15 minutes. Currently, we have several dts packages that go and grab the files and put them on the sql server.1. Is there any way to pass a filename to a package (or read it from a table inside the package) and have the ftp task called, I have used the task before, but its always been hardcoded.i feel like crap.I am starting to think I am going to have to make a visual basic app to handle this.2. Do dts global variables work well enough to trust?thanks,taking out a patent on my hangover.________________________________________________(Beer + Beer + Beer + Beer + Beer + Martini w/French Vodka + Beer + Beer + Beer) = Sick |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-06-20 : 11:38:39
|
| You can do it from a stored proc and so the filename problem doesn't occur.http://www.nigelrivett.net/s_ftp_PutFile.htmlYou could probably set the source of the ftp task by accessing the object model.Something like this.http://www.nigelrivett.net/SetDTSRunTimeValues.htmlWhen I'm doing this I usually use VB to look at the objects in the package to create the activex code to set the properties.Global variables work OK and you can set them from dtsrun or the object model.==========================================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. |
 |
|
|
Vivaldi
Constraint Violating Yak Guru
298 Posts |
Posted - 2003-06-20 : 12:38:26
|
| Thanks,That is some interesting stuff.________________________________________________(Beer + Beer + Beer + Beer + Beer + Martini w/French Vodka + Beer + Beer + Beer) = Sick |
|
|
|
|
|
|
<hung over> DTS, file import