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 ...

When your source data is arranged in a non-standard format, you may find it more convenient to consolidate all your parsing logic in a single script than to chain together multiple ...

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 ...

Numerous techniques and solutions enable common forms of data cleansing, yet the same routines become tedious and complicated in the Microsoft ® SSIS (SQL Server ® Integration Services) platform.

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.