ComponentPro Blog

Posts Tagged ‘ssis’

Ultimate FTP in Microsoft Windows PowerShell

Tuesday, May 01, 2012

Step by step show you how to use the Ultimate FTP component in PowerShell to connect and transfer a file.

Tags //  ftp  powershell  sql  ssis  

How to use the Ultimate components in SSIS package

Wednesday, March 16, 2011

In order to use the Ultimate components in SSIS script task, you may need to register the components to SSIS and add reference to the components in the Script Task. The following steps illustrate how to register and use the Ultimate DLLs in SSIS package:

  1. To have our components listed in the VS References dialog, copy Ultimate assemblies into C:\Program Files\Microsoft SQL Server\90\SDK\Assemblies\.
  2. Add Ultimate assemblies into Global Assembly Cache (GAC) or copy the assemblies to C:\Program Files\Microsoft SQL Server\90\DTS\Binn.
  3. To use the component in SSIS Script Task, add reference to the needed components in the Project Explorer window.

Tags //  excel  ftp  mail  pdf  sftp  sql  ssis  zip