Monthly Archives: August 2012

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”