Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tpavan7329
Starting Member
18 Posts |
 Posted - 2012-06-14 : 05:04:11
|
| 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?Thanks,Pavan |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2012-06-14 : 05:30:44
|
| 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. |
 |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2012-06-14 : 12:24:58
|
| what are the columns in the mergejoin and the columns the destination table. please post schema?<><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
|
|
|
tpavan7329
Starting Member
18 Posts |
|
|
|
|
|
ado.net destination failure