I am having some difficulties executing a package after I added two new fields in the VFP table. Before I added the fields, I was able to run the package ok. So, at first, I went into the data flow object and added the two additional fields manually in the column mapping. When I checked the properties, everything appears ok. I can see the two additional fields I added manually in the column mapping and that they are pointing to their own occurence in the output source. But, whenever I run the package, I get this:
[Destination 4 - member [388]] Error: Cannot create an OLE DB accessor. Verify that the column metadata is valid.
[Destination 4 - member [388]] Error: Column "address2" cannot be found at the datasource.
[DTS.Pipeline] Error: component "Destination 4 - member" (388) failed the pre-execute phase and returned error code 0xC0202025.
I really can't find anywhere else to look. All seems to be properly configured to me.