Keep Identity tMSSQLBulkExec

Four Stars

Keep Identity tMSSQLBulkExec

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


Accepted Solutions
Four Stars

Re: Keep Identity tMSSQLBulkExec

Hi,

 

I found it !

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

This is a workaround but it works!

 

Regards,

Orlin


All Replies
Four Stars

Re: Keep Identity tMSSQLBulkExec

Hi,

 

I found it !

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

This is a workaround but it works!

 

Regards,

Orlin