How to run a local dtsx package within SQL Server Management Studio?

user_6485108 0
Viewed 15539

I have created a .dtsx file with the import wizard of SSMS and stored the file in the local file system. I can open this file with SSMS and get its XML content displayed in the Object Explorer.

Now I want to run this file with SSMS. I have tried the right mouse button and searched all available menu items, but could not find a command for executing the .dtsx file.

ssis ssms
2 Answers

Updated answer (I suppose this is windows only):

  • If you have visual studio, go to extensions, search for "Sql Server Integration Services Projects." That will just direct you to a download.
  • In any case, install the above mentioned... thing. It's fat, but painless (no options to worry about).
  • That will add dtexec to your path.
  • dtexec /f "YourPackage.dtsx"
user_740000
Related