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 |
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
 Posted - 2011-02-02 : 15:21:46
|
| GreetingsWhat would you recommend from your experience when hitting an external remote ftp site to extract/download a huge 4GB zip file: use a script or use ftp task?ThanksIf you don't have the passion to help people, you have no passion |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2011-02-02 : 15:37:51
|
I have used both within SSIS ..not much difference in performance IMO. Script is easier if you need to browse the remote location and evaluate the contents to determine what files to bring down.
Poor planning on your part does not constitute an emergency on my part. |
 |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2011-02-02 : 15:40:47
|
| thanks guruIf you don't have the passion to help people, you have no passion |
|
|
|
|
|
|
ftp using SSIS or some other script