A financial ETL process running every night fails at 2:00 AM with SSIS 903. The package processes 2.5 million rows from a flat file into a SQL Server table.
What is the of the error message shown in your SSIS execution log?
The error 0xC0209303 is a common, yet often frustrating, hurdle in SSIS development. It is a data flow error that almost always occurs when a connection attempt fails. You will typically see it in a message similar to: The AcquireConnection method call to the connection manager "YourConnectionName" failed with error code 0xC0209303 .
