Questions tagged [dtexec]
The dtexec command prompt utility is used to configure and execute Microsoft SQL Server Integration Services (SSIS) packages.
4
questions
2
votes
0
answers
409
views
Why does DTExecUI.exe run fine but DTExec.exe gives me an error?
When I try to execute an SSIS package with DTExec.exe with a batch file or in the command prompt it gives me error code 0xC0040019 Data Flow Task 1 (SSIS.Pipeline) data flow objects cannot be loaded. ...
- 21
3
votes
2
answers
298
views
dtexec returns immediately without any messages
I'm trying to setup a command-line call to dtexec to validate packages, using the project model. I'm calling dtexec like this:
dtexec /val /proj my.ispac /pack my.dtsx /rep v
Though the real ...
- 215
1
vote
2
answers
2k
views
One SQL Server. One SSIS. Two versions of DTExec.exe?
Is it possible to install and use the 2012 version of the DTExec.exe on a Server 2008R2/SSIS2008 box without installing SSIS 2012? All jobs will be called from the command line, no server agent jobs. ...
- 265
15
votes
2
answers
48k
views
How do I grant the privilege of connecting to SSIS?
Attempting to run SSIS packages using dtexec.exe, I got this error message:
Could not load package "D:\Filename.dtsx" because of error 0xC00160AE.
Description: Connecting to the Integration Services ...
- 5,772