Hello All,
I'm looking at some solutions for migrating data from SQL server to SFDC.
A feature I've experienced with a different product(DBamp) is that your can create two extra columns(Id,Error) on the source table. When inserting that data from SQL to SFDC it returns the relative data fro them two columns(Id,error) and updates them two fields.
I've seen that the output columns(ErrorCode,ErrorColumn,Id,Error Description) from the CozyRoc SFDC component, I would like the return values to be populated along side the row in the source table.
Can anybody confirm this can be done ?
I've seen the video on the CozyRoc website that it can be populated in a separate tab in a spreadsheet, but ideally I want it to return to an SQL table alongside the row it's related too.
Thank you in advance.
Regards Lee