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

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.