DataReader source error

[TeamGD]

I’m getting the following error message with a DataReader source:

The column <column name> does not have a matching source column in the DataReader schema.

The DataReader source’s Connection Manager is an Ado.Net connection. The Ado.Net connection has the Provider set to .NetProviders\ODBC Data Provider.

The tables behind the ODBC are C-ISAM.

Does anyone have any thoughts on how to fix and/or troubleshoot this?

Cheers

gmhm

 

[georgegd]

Hi

i'm new to ssis but am trying to set up the same sort of odbc connection as you are.

did you get a fix to the error "The column <column name> does not have a matching source column in the DataReader schema"?

The error occurs when trying to access a btrieve database, but i intend on connecting to a C-ISAM database once i have resolved this.

thanks.

 

[Catadmin]

Have you actually verified that the # of columns you are pulling from are equal to the # of columns in the source? What about names & datatypes? Do these match?

Did you go into the properties of the connection between the source and destination to make sure everything was properly mapped?



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"