How to migrate ADODB.Connection and ADODB.Recordset objects used inside ActiveX script to SSIS equivalent task/code?
Using ADO objects inside ActiveX Script task is very common in DTS. People use ADO objects (i.e. ADODB.Connection, ADODB.RecordSet etc) for many reasons but the most common use are – Creating connections at runtime – Executing Adhoc Queries at runtime – Processing certain data row by row Check the following example on how to convert ActiveX Script. It performs couple of things – Establish Connection to SQL Server using ADODB.Connection object – Execute SQL Query and Load the recordset using ADODB.Recordset object – Loop through each record to build HTML formatted string and email it.
