Welcome to MSDN Blogs Sign in | Join | Help

November 2006 - Posts

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

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
Posted by mmasson | 3 Comments
 
Page view tracker