This is an old revision of the document!
Using WinSCP .NET Assembly from SQL Server Integration Services (SSIS)
This feature is available only in the latest beta release.
Advertisement
Installing
First, you need to install the WinSCP .NET assembly.
You also need to install the assembly to the GAC1.
Using from SSIS
You use WinSCP .NET assembly from SSIS as any other .NET assembly:
- In your “Integration Services Project”, choose your “SSIS Package” (e.g. the default
Package.dtsx
); - Drag Script task from Toolbox onto Control flow view of the package;
- In the context menu of the task, choose Edit;
- On the Script task editor click Edit script button;
- SSIS can only use assemblies installed to GACBack