Question Can't run DTSX after creating one

[IBMJunkman]

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?

 

[igor_kavinski]

SQL Server Integration Services Projects - Visual Studio Marketplace

Extension for Visual Studio - This project may be used for building high performance data integration and workflow solutions, including extraction, transformation, and loading (ETL) operations for data warehousing.

marketplace.visualstudio.com

Install. Then run with

dtexec /f "YourPackage.dtsx"

 

[IBMJunkman]

The install asks me to pick the VS I want to install to. The list is empty.

 

[igor_kavinski]

Try this: https://marketplace.visualstudio.com/items?itemName=SSIS.MicrosoftDataToolsIntegrationServices

 

[IBMJunkman]

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.