CODEWITHSUNDEEP
sql-serverssis
David Nguyen
David Nguyen

Reputation: 8528

Upgraded SSIS package fails to run, "must install Standard Edition of Integration Services"

I was forced to upgrade my SSIS packages using VS2015 + SSDT, however I'm unable to get the compiled dtsx files to run now through command line using 130\DTS\Binn\DTExec.exe

Full error:

 Source: Process file data flow SSIS.Pipeline
 Description: To run a SSIS package outside of SQL Server Data Tools you must install Standard Edition of Integration Services or higher.

I've reinstalled MSSQL2014 w/ integration services and I see SQL Server Integration Services 12 is running.

Upvotes: 2

Views: 6232

Answers (2)

sirdank
sirdank

Reputation: 3571

I received this error from double-clicking a DTSX file which opened the Execute Package Utility from C:\Program Files\Microsoft SQL Server\140. I couldn't get it to work until I:

  1. Saved off the command line from the "Command-line" tab of the utility
  2. Navigated to C:\Program Files\Microsoft SQL Server\130\DTS\Binn
  3. Called dtexec.exe with the command line

I think the Execute Package Utility was somehow looking for SQL Server 17 while I only had SQL 16 installed. DTExec.exe was able to find SQL 16 ok.

Upvotes: 0

Tarzan
Tarzan

Reputation: 4538

DTExec.exe gets installed when you pick the "Integration Services" option off the setup CD. Make sure that it's installed in the directory indicated in the command line. You also need to make sure that the versions match between the SSIS package and DTEXec.exe. "..\120\DTS\Binn\DTExec.exe" is used for MSSQL2014.

Upvotes: 2

Related Questions