Stack Overflow
Stack Overflow

Questions tagged [dtexec]

DTExec is a tool used to configure and execute SQL Server Integration Services (SSIS) packages. Many developers and database administrators use this tool, especially when automating the package execution using third-party applications or non-supported programming languages.

DTExec tool is a command prompt tool developed by Microsoft used to configure and execute SSIS packages without needing the Business Intelligence Development Studio or SQL Server data tools. It can run SSIS packages from a file system (.dtsx), a project file (.ispac), the msdb database, the Integration Services server, or the SSIS package store.

###References

99 questions
12
votes
1 answer

Is it possible to pass parameters to a .dtsx package on the command line?

I am currently executing an SSIS package (package.dtsx) from the command line using Dtexec. This is as simple as: dtexec /f Package.dtsx However, I have some parameters that I would like to pass to the package for it to use during execution. The…
Hoppy
  • 720
  • 2
  • 12
  • 24
9
votes
2 answers

Execute Package Utility (dtexecui) not installed after installing SQL Server 2017

I was not able to find Execute Package Utility (dtexecui) after installing SQL Server 2017. Was not able to find any standalone installer from Microsoft to install it as well. Will any one please guide me on installing it to run my SSIS Packages?
CDD Gateway
  • 91
  • 1
  • 1
  • 2
8
votes
1 answer

dtexec error - setting multiple variables

Am trying to execute SSIS package with dtexec command line utility. my syntax for dtexec is as follows: dtexec /FILE "C:\DirectLoads\RefEDWDirectLoads.dtsx" /Set \Package.Variables [User::SourceDirectory].Properties[Value];"C\Test" /Set…
Sreedhar
  • 29,307
  • 34
  • 118
  • 188
8
votes
3 answers

Unit testing of SSIS Package with tSQLt

I really like tsqlt to test procs and functions, but really would like to be able to also execute SSIS packages and take advantage of FakeTable and AssertEquals to determine if it was the SSIS package did what it was supposed to. Has anyone explored…
duyker
  • 800
  • 9
  • 17
5
votes
0 answers

Execute SSIS package with proxy account from command line

I need to run SSIS2016 package from older SSIS (another server) because of extending legacy system. The package runs fine from SQL Agent, but I am unable to run it using tsql or DTEXEC. The problem is that package is unable to access network even…
MightyPolo
  • 103
  • 9
4
votes
1 answer

How SQL Server maintenance plans work in relation with Jobs and DTExec?

How SQL Server maintenance plans work in relation with Jobs and DTExec? I am specially interested in the maintenance plan's local connection which seems to be passed somehow to dtexec. I have read some docs but none of them is clear enough. As I…
IgnacioJ
  • 105
  • 11
3
votes
1 answer

Dtexec ISSERVER returns is not a valid server package path

I am executing a SSIS package via master..xp_cmdshell from a stored procedure and I am always getting the error "Description: '\SSISDB\Main\Projects\ProjectName\Packages\PackageName.dtsx' is not a valid server package path." I tried various…
Arvindakshan
  • 61
  • 6
3
votes
3 answers

To run a SSIS package outside of SQL Server Data Tools you must install Standard Edition of Integration Services or higher

I am trying to run the SSIS package from a batch file,but it's throwing an error To run a SSIS package outside of SQL Server Data Tools you must install Standard Edition of Integration Services or higher. But in Visual studio i can able to…
srikanth
  • 41
  • 1
  • 6
3
votes
1 answer

SSIS Command line - ORA-00907: missing right parenthesis

I am trying to run a SSIS package from command line but I keep getting this "ORA-00907: missing right parenthesis". The package runs fine from the SSDT and the query I am using is also a simple one. I do try to pass values to the query at…
Rohit
  • 1,520
  • 2
  • 17
  • 36
3
votes
0 answers

Having xp_cmdshell error running DTSX file

To export some data to a text file, I used the wizard in SSMS 17.x to create an SSIS file, and it ran fine from the wizard, but it gives me an error when I try to execute it again using xp_cmdshell, like this: EXEC xp_cmdshell 'DTExec /f…
Brian Battles
  • 971
  • 1
  • 7
  • 19
3
votes
2 answers

How to launch cmd.exe to execute DTExec using Task Scheduler?

I'm trying to automate a SSIS package using dtexec via Task Scheduler (as I do not have rights to create it via SQL Agent) and need it done locally on my machine. I referenced this post: How to launch cmd.exe to execute command using Task…
TWaller
  • 81
  • 1
  • 7
3
votes
3 answers

DTexec /ISSERVER path for package

When I try to execute a SSIS package created in sql server data tools (vs 2010) using dtexec, I receive an error "is not a valid server package path". The documentation says use: dtexec /ISServer [path to package]. If I connect via SSMS I can browse…
user1910428
  • 169
  • 2
  • 6
2
votes
1 answer

Passing Project parameter to dtexec

My SSIS package has a project parameter called SMTPServer. I pass that parameter like below when executing dtexec: "E:\Program Files\Microsoft SQL Server\110\DTS\binn\dtexec" /Server {myDBServer} /ISServer "\SSISDB\mySSIS.dtsx" /Par…
faujong
  • 949
  • 4
  • 24
  • 40
2
votes
1 answer

Package Source Path not populated while using DtExecUI.exe

I had SQL Server 2008 installed earlier. I had the ability to right click on any SSIS package and select Open With "SQL Server 2008 Integration Services Package Execution Utility" as an option to run the package standalone. Recently, we upgraded…
Sam
  • 392
  • 1
  • 6
  • 18
2
votes
2 answers

Run a SSIS Package Using Batch File

need some help in executing my SSIS package from command prompt. below is the path of my DTExec file and the package path. when i run this , i am getting an error "missing argument for option "file" "C:\Program Files (x86)\Microsoft SQL…
Data Enthusiast
  • 37
  • 1
  • 2
  • 4
1
2 3 4 5 6 7