Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Metadata errors moving from Testing to Production Expand / Collapse
Posted Tuesday, March 26, 2013 3:22 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, November 14, 2016 3:09 PM
Points: 558, Visits: 879
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.
Post #1435342
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse