Guys, I really need some life saving help on this one!
I have a package that uses Progress 10b OpenEdge ODBC drivers. We have a system DSN created on the TEST box which connects to a DEV progress database and the package works just fine.
When we modify the ODBC connection to point at the migration testing environment I get the following error message from one of the dataflow tasks which carries out a slowly changing dimension upsert.
"The external metadata column collection is out of synchronization with the data source columns..."
I have pulled the .df (table definition file) from the DEV and TEST environments and there are not differences in the columns or indexes. Any idea why I would be getting this error message and how to fix it. Unfortunately using BIDS does not seem to be an option because:
a) the package is deployed on a 64bit VM server with the OpenEdge10b 64 bit drivers and BIDS2005 is a 32bit application and won't run the 64bit ODBC
b) Because the test db contains live data it takes an act of GOD to get a username and passoword on a development machine so I can't recompile against the TEST server.