Keep Identity tMSSQLBulkExec

Anonymous — Tue, 23 Jan 2018 12:06:14 GMT

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

Re: Keep Identity tMSSQLBulkExec

Anonymous — Tue, 23 Jan 2018 13:25:38 GMT

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

topic Re: Keep Identity tMSSQLBulkExec in Talend Studio

Keep Identity tMSSQLBulkExec

Re: Keep Identity tMSSQLBulkExec