Data Import Transform Map with sys_id

[brycegodfrey]

I'm trying to import some data from one instance to another using the XML data source (table.do?XML).   I have a transform map that tries to set the sys_id on the target from the import table u_sys_id field.   I can see the import table get populated with the sys_id of the source table, but the records are being created with a generated sys_id every time.   I have set the coalesce field, and the mapping looks proper... I'm just not sure what I'm missing or if this is possible on the core_company table?

[adiddigi · Accepted solution]

If you want to set the same sys_id, co-lease isn't enough. You will have to follow the steps in the below page:

http://wiki.servicenow.com/index.php?title=Importing_from_Another_ServiceNow_Instance#Add_a_Field_Ma...

[brycegodfrey]

Thanks Abhiram, I did not realize that the 3.4 section was required also. Solved my problem!

[adiddigi]

Please mark this question as "answered" if it he;pmed you. Thanks!

[Manikanta4]

Getting error while opening the link. Please provide the activated link. Thanks in advance