Question Can't run DTSX after creating one

IBMJunkman

Senior member
May 7, 2015
678
217
116
SQL Server 2022. Run the SQL Server 2022 Import and Export Data (64 bit) and go through all the steps to create a DTSX file. Select Run Immediately and Save at the same time. Does the update fine and saves the DTSX.

Later I double click on the DTSX file. I get a popup asking what program I want to use to run it. I select the Import and Export program. The program then starts me through the build process again.

How do I run an existing DTSX?
 

IBMJunkman

Senior member
May 7, 2015
678
217
116
That one worked but I stopped the install. I will try it if I have problems.

I created a dtsx but used a different connection type. The dtsx worked updating the local databse using the /F option. The Provider in the dtsx is SQLOLEDB.

When I have some new data to update GoDaddy database I will create a new dtsx with the same Provider and see what happens.

Thanks for your help.
 
  • Like
Reactions: igor_kavinski