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 |
|
ahmedauk
Starting Member
4 Posts |
 Posted - 2007-06-12 : 06:27:49
|
| Hi,I need to setup an automated process - where i take a file from an FTP site (always put on there 1st of the month) load that into sql server, run some data manipulation and then extract to a text file and upload to another FTP site.I currently have the process setup where I run a stored procedure that loads the file(DTS), does the manipulation and extracts the data(DTS) - i need to set some parameters (input file name and output file name)Can I add the downloading from and FTP site and uploading to an FTP site in this process - i would then be able to set it on a schedule and only check reports!!Thanks,AA. |
|
|
chrisrock
Starting Member
12 Posts |
Posted - 2007-06-12 : 08:37:29
|
| We are accomplishing this same task using SSIS in SQL 2005. Do you have any experience with SSIS? |
 |
|
|
ahmedauk
Starting Member
4 Posts |
Posted - 2007-06-12 : 10:29:11
|
| no - any recommended reads?? |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-12 : 11:36:01
|
| Or create seperate job steps for each ftp with dos command. |
|
|
|
|
|
|
Trying to setup a process