CODEWITHSUNDEEP
ssisssms
Manu
Manu

Reputation: 1470

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

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.

Upvotes: 16

Views: 38511

Answers (2)

Troy Witthoeft
Troy Witthoeft

Reputation: 2666

Double-clicking a .dtsx file should launch the DTExec GUI.

enter image description here

If you want to run in SSMS, then you will need to use a SQL Server Agent job.

enter image description here

enter image description here

If you see yourself developing and running many packages, use the SSISDB Catalog to store, manage, and execute packages.

Upvotes: 15

dudeNumber4
dudeNumber4

Reputation: 4697

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"

Upvotes: 5

Related Questions