//
archives

SSIS

RSS feed for this section
This category contains 2 posts

Configure DTC for distributed transactions

Posted by ⋅ ⋅ Leave a comment

This post describes how to configure the Distributed Transaction coordinator to allow  distributed transactions. The issue arose developing an SSIS package. The SSIS package consisted of two Execute SQL tasks within the same container. Each task updates a different SQL Server. (fig 1 below). fig 1 – SSIS package Initially, when the container Transaction option … Continue reading →

Passing variables to a SSIS package from SQL Server

Posted by ⋅ ⋅ Leave a comment

To run a package from the SQL Server Agent and pass in a parameter, Create a SQL Server Agent Job as usual. The Job Step Type is “SQL Server Integration Services Package”. In my example, the Package source is “File System”. Select the package location and then move to the Command Line tab. Add the … Continue reading →