Share via

Run a dtsx file from VS

Dom 941 Reputation points
2022-12-13T13:18:19.433+00:00

So I created a dtsx file with the Import Wizard in SSMS. I added it to an existing project in VS. I don't appear to have any way to EXECUTE the package from within VS. What step/application am I missing?

270151-2022-12-13-08-10-38-window.png

270056-2022-12-13-08-11-56-odin-mk2-microsoft-visual-stud.png

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,702 questions
Developer technologies | Visual Studio | Other
0 comments
Accepted answer
  1. Yitzhak Khabinsky 26,586 Reputation points
    2022-12-14T17:07:36.997+00:00

    Hi @Dom ,

    1. You need to create a brand-new VS Project for Integration Services (SSIS).
      Integration Services Project template.
    2. It will allow you to add the existing on the file system SSIS package file "Import Data from B&M ....dtsx" to it.
      The same *.dtsx file that your screen shot shows.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 41,491 Reputation points
    2022-12-14T07:31:52.423+00:00

    Hi @Dom ,

    Please right click the package and then execute it.

    270493-untitled.png

    In addition, you should add the dtsx file from the ssis package menu like shown below.

    270475-untitled.png

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.