Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Execute SQL Task   (RSS)
Thursday, September 13, 2007 9:28 AM

Capture PRINT messages from a stored procedure

I recently helped with a customer issue where they had a long running stored procedure which output status messages periodically using PRINT statements. They wanted to capture these statements and output them into the SSIS log. Unfortunately, the Execute
Posted by mmasson | 5 Comments
Wednesday, April 18, 2007 9:02 PM

Why can’t I store my BIGINT result in an Int64 variable?

The native providers (OLEDB, ODBC, ADO – ADO.NET doesn't have this problem) in the Execute SQL Task return the BIGINT type as a String, and not an Int64 as you'd expect. Attempting to store the result in an Int64 variable gives you an error along the
Posted by mmasson | 1 Comments
Filed under:
Wednesday, November 08, 2006 4:07 PM

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