February 2, 2011 at 1:13 am
I have one requirement where I need to upload and download near by 5 GB of files from different servers.
Any suggestions.
Abhijit - http://abhijitmore.wordpress.com
February 2, 2011 at 2:22 am
Use FTP?
Preferable an FTP tool that can resume an interrupted transfer, since you have fairly large files?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 3, 2011 at 8:15 am
Use compression, too - zip/unzip.
February 9, 2011 at 3:47 am
Yes only FTp Task help yopu in this senario.If you want to make speed of download and upload the file to ther server better you zip the file and do the task.
February 9, 2011 at 7:13 am
Given the form of your question, I assume you're looking for a tool?
Try SSIS. It has an FTP task within the tool (which is why there's some confusion) and it comes with SQL Server. Also, you can use the Data Flow Task to set up import / export from other Servers without having to go the file route (Export to file, Import file to SQL Server).
If you have files, then you can go the BCP Utility route or use T-SQL for BULK INSERT. Assuming that this is a one-off. If this task has to be repeated, I advise sticking with SSIS.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply