Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Metadata errors moving from Testing to Production Expand / Collapse
Author
Message
Posted Tuesday, March 26, 2013 3:22 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 4:26 PM
Points: 386, Visits: 622
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