I have 2 sources mysql and MS SQL and i join them by mergejoin and then i have to import into mysql table. I have all the steps successful except the insert step into mysql. I get below error.
ERROR: ----------- [ADO NET Destination [1086]] Error: An exception has occurred during data insertion, the message returned from the provider is: Unknown column 'p1' in 'field list' -------------------------------
I do not even have this column in the table and i tried all kind of stuff like adding few columns, swapping, recreating table but no luck. Can someone help me with this?
Sounds like the driver doesn't support mysql properly. Try checking the external columns in the mapping - otherwise can you select a different connection type?
========================================== Cursors are useful if you don't know sql. SSIS can be used in a similar way. Beer is not cold and it isn't fizzy.
ado.net destination failure
Posted - 06/14/2012 : 05:04:11
