Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with a field in the package
Message
From
16/10/2006 02:18:06
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Title:
Problem with a field in the package
Miscellaneous
Thread ID:
01162164
Message ID:
01162164
Views:
63
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.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Next
Reply
Map
View

Click here to load this message in the networking platform