Stored procedures with output parameters

When executing Stored Procedures with the Execute SQL Task, SSIS passes the statement to the underlying provider without parsing it. While efficient, the different ways of handling the input between the various providers can be a little frustrating. I was working on a couple of issues found in SP1, and realized that when dealing with…


Conditional Constraints

Here’s a more practical example of using constraints based on variables. I have a package that requires an existing database file to be attached to the local SQL Server. The package is synced out to multiple machines from a source control system and run frequently. I don’t want to manually setup the database on each…


Using Constraints and Expressions

Besides the regular Success and Failure constraints, you can create precedence constraints that are linked to an expression. In this example, I have a Script Task that determines the course for the workflow. Besides the pass and fail, I also want to handle a third case that will be executed whenever a special condition is…


Welcome!

I guess it’s only fitting that the first blog post is about the blogger himself!   My name is Matt, and I’ve recently moved to the Redmond area to work for Microsoft as a Software Design Engineer (SDE) on the SQL Server Integration Services team. I’ve been working in the BI field for the past…