Does anyone have any info on how to set up SFTP in SSIS package. with out using taskfactory from pragmatic works? #sqlhelp

@SQLYard If you host both, You could also export to a Folder share and just map that folder share to an SFTP account. As long as the SFTP service has access to that share you should be able to accomplish your goals in "uploading" the folder

@SQLYard I installed putty and called a batch file from SSIS to get mine to work.

@SQLYard Script Task is my choice too.

@SQLYard Find an SFTP command-line client and use that? :) #sqlhelp

@SQLYard we usually use sqlcmd for export to csv and then we upload to ftp via a winscp script