Tag Archives: SSIS

SSIS Package Upgrade then error “Cannot use the OUTPUT option when passing a constant to a stored procedure”

I have been recently upgrading SQL Server 2005 SSIS packages to 2008 R2 using the automated wizard. The wizard performed the upgrades without error, however on executing the packages I would get the following error in a data flow OLE … Continue reading

Posted in SQL 2005, SQL 2008 R2 | Tagged | Comments Off on SSIS Package Upgrade then error “Cannot use the OUTPUT option when passing a constant to a stored procedure”

SSIS Processes An Incorrect File with Success

Whilst loading data into production I made the mistake of giving SSIS the wrong text file for processing!. What happened was that the file was processed! Investigation into why resulted with the following finding: • On ‘PreExecute’ the following warning … Continue reading

Posted in SSIS 2005 | Tagged | Comments Off on SSIS Processes An Incorrect File with Success