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?
Solved! Go to Solution.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.