CODEWITHSUNDEEP
sqlssis
TWaller
TWaller

Reputation: 81

How to run a SSIS Package which has a file based source automatically

I have a similar issue as this question: How to run a SSIS Package which has a file based source and a target. At first, there was no known program to open the dtsx package (my package grabs a table from one server and places it on another). I did some digging and found the DTEXECUI program file, and now it does open the Execute Package Utility, but it doesn't populate the Package Source (file) or Package Name (Desktop\xxx.dtsx). How can I get it so that double-clicking the file just executes the SSIS package - or at least populates the names for the file I clicked on? Thanks in advance. DTEXCUI

Upvotes: 3

Views: 1131

Answers (1)

sorrell
sorrell

Reputation: 1861

I'm guessing that since Windows didn't automatically create that association for you, the default is missing some parameters for the executable (because that program should open with those fields populated).

Try this:

  1. Download Default Programs Editor and run it
  2. Click File type settings
  3. Click Context menu
  4. Locate .dtsx in the list and click Next
  5. Click the Open list item and then Edit Selected Command dpe edit
  6. The path should look something like "C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\ManagementStudio\DtExecUI.exe" /F "%L" - your path to the DtExecUI may be different, but of special note is the /F "%L"
  7. Click Next and then Save Context Menu

Upvotes: 1

Related Questions