Using a DTSX file with GoDaddy

Joined
Apr 29, 2023
Messages
19
Reaction score
1
I have 2 SQL databases. One is 2008R2 on Win 10. The other is 2022 on Win 11. On Win10 I use MSSM 10.5. On Win11 I use Management Studio 20.1.10.0.
I have a DTSX file I use to update the local DB. The input is a CSV file. On the Win 10 machine I click on the file and the Execute Package Utility opens. Set the values needed and click on Execute. Works fine. On the Win 11 machine VS grabs the DTSX. I found dtexec /f to run the DTSX. Works fine.
On either machine when I connect to my database on GoDaddy and run the DTSX it terminates with a duplicate key error. The first key on the CSV file is 4228. If I run a SELECT MAX(FIELD) FROM XXXX I get 4227.

At this point I don't remember if I used a DTSX in the past or did something else to load data in the GoDaddy DB. I know I have not done an update since GoDaddy moved my database to another server.

Ideas?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,780
Messages
2,569,611
Members
45,286
Latest member
ChristieSo

Latest Threads

Top