Keep Identity tMSSQLBulkExec

[Anonymous]

Hi,

I am working on job which offload data from 1 mssql db to another mssql db. I offload the data successfully using tMSSQLBulkExec, but I noticed that my primary key is not identical as the one specified in the ".csv" file
What I want is to keep identity while doing bulk insert!
This is possible using SQL (https://docs.microsoft.com/en-us/sql/t-sql/statements/bulk-insert-transact-sql), but I didn't notice option to do that using tMSSQLBulkExec

How can I keep identity with mssql bulk operation in talend?

Thanks,

Orlin

[Anonymous · Accepted solution]

Hi,

I found it !

Add KEEPIDENTITY next to First Row number, like this : "0, KEEPIDENTITY"

This is a workaround but it works!

Regards,

Orlin

tMSSQLBulkExec_keepidentity.png