The SFTP and FTP/SSL component included in File Transfer Pack was not especially designed to run inside the SSIS (SQL Server Integration Services). However, with little effort both components can be used from inside the SSIS "script task".
Registering the component for use in IDE for SSIS packages
Registering the component for use in normal VS.NET is easy. Just use "Add Reference" and click on "Browse" button. Unfortunatelly, the "Add Reference" dialog in SSIS IDE does not allow adding reference by browsing the assembly on the disk. It offers only pre-registered assemblies.
To register the component for use in SSIS package:
- Copy Rebex assemblies (DLLs) into C:\Program Files\Microsoft SQL Server\90\SDK\Assemblies\ - this should make them appear in the Visual Studio for Applications "References" dialog.
- Add Rebex assemblies into Global Assembly Cache (GAC) - this is needed in order to make it possible for SSIS to run them.
- One user has also reported that copying the assemblies to C:\Program Files\Microsoft SQL Server\90\DTS\Binn instead of putting them into the GAC is sufficient too.
Similar problem is discussed in newsgroup post on Microsoft website.
Using the component from SSIS
- Add new Script Task
- Modify the script via the "Desing script" in "Properties dialog". The Visual Studio for Applications IDE pops up.
- Add reference to the dlls in the Project Explorer window. The SFTP and FTP/SSL components should be listed in the Add Reference dialog now.
- Add the code to connect, transfer files or do whatever you want as described in SFTP and FTP/SSL tutorials.
Adding the references for the SSIS Script Component (used in data flow task) is similar.