We are in the process of migrating from a SQL2005 data warehouse solution to a SQL2008. We have used an ODBC connection to our informix patient management system for a...

Can you check the the Data Flow Destination setting? Is it 'Table or View - Fast load' or 'Table or View'.

My experience has been that if you select the second...