SSIS doesn't have a built-in component to support SFTP but the following codeplex component can be used or create a script task and write the SFTP file retrieval.
http://ssissftp.codeplex.com/Note:
- Copy the SSISSFTPTask100.dll to C:\Program Files(x86)\Microsoft SQL Server\100\DTS\Tasks\
- Register the SSISSFTPTask100.dll in the GAC using gacutil.exe (available under C:\Program Files(x86)\Microsoft SDKs\Windows\v7.0A\Bin)
- Open BIDS and click Tools > Choose Toolbox items > SSIS Control Flow Items > SFTP Task (Note: The SFTP Task will appear only if the SSISSFTPTask100.dll has been successfully registered in the GAC.
No comments:
Post a Comment