what is the difference between xtk.session.write and sqlExec in terms of inserting and updating the data in schema

[DishaSharma]

@Parvesh_Parmar ,@AkshayAnand 

,@isahore ,@AndreaBriceno,@ParthaSarathy

,@ParthaS ,@Craig_Thonis ,@Manoj_Kumar_ ,@Amine_Abedour ,@Marcel_Szimonisz,@DavidKangni 

,@Amit_Kumar,@ShashankNigam02,@Ganesh5067, @Jonathon_wodnicki

@Amine_Abedour 

Hi All,

what is the difference between xtk.session.write and sqlExec in terms of inserting and updating the data in schema

when we should use xtk.session.write and sqlExec in terms of inserting and updating the data in schema

[AkshayAnand · Accepted solution]

Hi @DishaSharma 

The main difference between those are :-

sqlExec executes an SQL script whereas Write uses and XML Doc.

Both can be used to Upsert data according to use cases.

Thanks

Akshay