I am creating one SSIS package to import data from SQL server table to csv file. Further, I need to to transfer this file to remote server using FTP. I am thinking of creating another package using SSIS FTP task to achieve this. But, I have question here. Will it handle large size file transfer as well more than 1 GB. can you please suggest if there is any alternate way AFT etc. SandyLeo

Are you having multiple files being created and then sent to the FTP destination. If thats the case I would suggest you have 2 separate packages one to create the file and other for file transfer as it would isolate the 2 processes and easier to transfer files after the files are created. The size of the file should not be an issue but yes it will take time to load the file to FTP as IO operations depend on lot of other factors. Alternate way I do not think you would need that as SSIS would do well. Tweet me..

No, I am creating and sending only one file. In this case, do we need to write any bach script for FTP? How this package will run? SandyLeo

If you are creating one file still i would suggest you create 2 package for the same. In case there is an issue with the file upload you donot need to run the 1st part to create the file which would take time and resource. You donot need to write a batch Script for FTP just use the FTP task provided in SSIS. In case you are using sFTP then you would have to look into other options. Tweet me..

You could use either "FTP task" component or "Script task" component to FTP your file. If you decide to use two packages you have two options: "Execute Package Task" component to execute a package to generate a file "Execute SQL Server Job" component that points to a package to generate a file Both packages are relatively simple. Sergei

Will it work for even file with 20-30 MB size.SandyLeo

Will it work for even file with 20-30 MB size. SandyLeo If it will work for a file more than a GB it will definitely work for smaller files. Tweet me..