Archive for

SSIS Package Fails with Stored Procedure as Data Source (error code 0xC02092B4)

If the execution of a stored procedure as an OLE DB data source fails in your data flow  with the following errors: Error: A rowset based on the SQL command was not returned by the OLE DB provider. Error: component “XYZ” (1) failed the pre-execute phase and returned error code 0xC02092B4. Try the following corrections … Continue reading