When you add a Script component to the Data Flow tab of [!INCLUDE ssIS] Designer, the Select Script Component Type dialog box opens and prompts you to select a Source, Destination, or Transformation ...

Demonstration code for an SSIS script component that consumes data from a REST API This code retrieves currency exchange data from the Bank of Canada API. Read the slides for details on the ...

Since SSIS 2008 allows you to add web references in the Script Component, we will add the two web service references in this step. Please be aware that you must save the script component project by ...

Melissa Data Corp, a provider of contact data quality and integration solutions, introduced its SmartMover Component for Microsoft's SQL Server Integration Services (SSIS) at the PASS Summit 2011.