Share via

Run a dtsx file from VS

Dom 951 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
Developer technologies | Visual Studio | Other
Developer technologies | Visual Studio | Other
A family of Microsoft suites of integrated development tools for building applications for Windows, the web, mobile devices and many other platforms. Miscellaneous topics that do not fit into specific categories.
0 comments
Answer accepted by question author
  1. Yitzhak Khabinsky 27,091 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,536 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' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.