This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 40%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have a situation where I receive a delta export (tables only) generated by AWS DMS. I want to import this data. My concern is that I have Primary Key Constraints enabled in the target SQL server. My question is does anyone know if I am able to import the .csv-file generated by DMS without issues?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
How about SQL Server Integration Services (SSIS) for the task?
Hi @AlanTHarris,
You may use SSIS to load csv file to sql server table.
Check it out here:
https://blog.sqlauthority.com/2011/05/12/sql-server-import-csv-file-into-database-table-using-ssis/
Regards，
Zoe Hui
If the answer is helpful, please click "Accept Answer" and upvote it.
Do you have further question on this, could we offer more support? If this helps on your issue, you could mark it as answer so other user with similar problem could see this easier. :)