Tag Archives: SQL Server Management Objects

SSIS: Using the Script Component to Insert Rows and Retrieve Newly Created Keys

In the last post I demonstrated using SQL Server Management Objects (SMO) to extract information on installed SQL Server instances. In this post the script component will be used as a transformation task, ¬†addressing a common scenario of inserting rows … Continue reading

Posted in Data Integration, Database BI, Uncategorized | Tagged , , | Comments Off on SSIS: Using the Script Component to Insert Rows and Retrieve Newly Created Keys