Data Source: I'm trying to read data from an Access database
I created a OLE Jet 4 connection through to an access DB. The connection worked and I could view data from within the actual data source flow object. However when I try and run the package I get an error
'[DTS.Pipeline] Error: component "Read Access Table Rejected_And_Corrected" (1) failed validation and returned error code 0xC020801C.'
I can right click on the toolbox select 'Choose Item' and select the 'AccessDataSource' in the '.NET Framework Components'. When I click OK it doesn't appear below the group 'Data Flow Sources'.
However, if I right click on the toolbox and select 'Show All', it does appear below 'Data Flow Sources' except it is greyed out.
I tried to create an ODBC connection 'Connection Manager' but get the same problem. I check the ODBC boxs under '.NET Framework Components' and they show up greyed out.
What am I missing?
Thanks for your help
