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
1
vote
1 answer

DTExec not finding file

I have a package created, which is loaded onto our SQL server. The package goes into a folder, reads and excel, dumps the excel into a table and then archives it. When running the package normally (through BIDS) it works perfectly fine. But when I…
Caveman42
  • 679
  • 2
  • 13
  • 35
1
vote
0 answers

SSIS Asynchronous Pattern Issues

I'm reposting this from a Msft forum hoping to get more responses here. Apologies if that is frowned upon. ... I'm currently looking at refactoring an existing, large SSIS 2012 implementation that consists of about 55 projects and 360+ packages. The…
d.elish
  • 29
  • 3
1
vote
1 answer

SQL SERVER 2012 - IntegrationServices (Assign values to variables in 2012 SSIS Package)

Can i assign values to variables in 2012 using below command I have used the same command in 2008 and it works fine. DTEXEC…
dunes
  • 41
  • 2
1
vote
0 answers

Odd Script Execution SSIS

I'm probably going to word this poorly, but here goes. I've created an SSIS Package with an email proceedure. It is supposed to send three emails, each one based on a SQL query. The email tasks run sequentially, as part of the reporting…
Suburbanpsyco6
  • 67
  • 2
  • 7
1
vote
1 answer

How long does it take for SSISDB to record package execution status?

I am running a series of SSIS packages using DTEXEC in Powershell. The packages reside in SSISDB. I have no trouble running a package, but I am running into problems determining the actual result status once the package has completed. When a package…
James Page
  • 91
  • 1
  • 3
1
vote
0 answers

CommunicationChannel faulted - DTexec vs. SQL Job Agent

I have a SSIS package with a Script task in it. In the script I use IRequestChannel to communicate with SAP RFC programme. Weird error is, that if I run the package via dtexec, I get the error message that my channel is in a faulted state and the…
Chris
  • 11
  • 1
1
vote
2 answers

ORA-12541 error when deploying SSIS package to a server

I am connecting SSIS to Oracle OLEDB connection using below connection string.. Data Source=Server_Name;User ID=U_Id;Password=Pwd;Provider=MSDAORA.1; It works on my machine but when i run on SSIS server using C:\Program Files (x86)\Microsoft SQL…
Pritesh
  • 1,938
  • 7
  • 32
  • 46
1
vote
1 answer

Can we install SSIS engine without BIDS etc? If yes would it be good idea to do it on production machine

I have brand new Windows machine which we are planning to use as production machine to run our SSIS packages. My pacakges are on filesystem not in SQL Server. Is it possible we can install SSIS Engine only without BIDS. Will utility like dtexec work…
Pritesh
  • 1,938
  • 7
  • 32
  • 46
1
vote
1 answer

calling SSIS package with input parameters on stored procedure

I have SSIS packages that is expecting an input parameter ID(integer). I need to execute this SSIS package using stored procedure so that I can pass the value of the ID. DECLARE @Command varchar(1000) , @PackageLocation varchar(1000) ,…
dmarkez
  • 73
  • 1
  • 2
  • 11
0
votes
1 answer

Error Running DTEXEC 64 bit from command line

I'm migrating all my SSIS packages and solution to Visual Studio 2022. When I try the packages inside visual studio they run ok without problems. But when I try it from cmd and I get this error: Microsoft (R) SQL Server Execute Package…
Pablo Costa
  • 1
0
votes
1 answer

How to run dtexec remotely

On my work i have a situation that we have a three tier setup: Database server Application server Clients We work with SSIS packages which are stored in Database Server (on a share) but are called from a external scheduler in the application…
Erik hoeven
  • 1,442
  • 6
  • 26
  • 41
0
votes
0 answers

Execute DTExec file via Command Line

I've got a dotnet core 6 project where I need to execute SSIS packages via dtexec. So far I have the following code: private void ExecutePackage() { var processOutput = string.Empty; var processErrorOutput = string.Empty; …
N0xus
  • 2,674
  • 12
  • 65
  • 126
0
votes
0 answers

Is it still possible to run SSIS Packages from DTEXECUI or similar?

My organization depends on SSIS packages to be run by data entry folks who are not trained, qualified, nor the least bit interested in database development. In our old SQL Server implementations (2008, 2012) they were able to install a standalone…
TalonKarrde
  • 1
  • 1
0
votes
0 answers

DTExec.exe fails when running from a PowerShell script from remote

I'm trying to run the following PowerShell script on server A to a remote server B (REMOTE_PC): $username = 'domain1\user22' $password = ConvertTo-SecureString -String 'PASSWORD' -AsPlainText -Force $Credential = New-Object -TypeName…
ShaiO
  • 153
  • 1
  • 10
0
votes
0 answers

Error while trying to run package with dtexec

I'm attempting to run a package from command line with plans to schedule the run via batch. I enter the following dtexec /Project "C:\Users\XXXXXX\Documents\Batch\ScheduleRun\ScheduledRun\ScheduledRun" /Package "batchrun.dtsx" generates this…
SJJ9166
  • 71
  • 1
  • 6
1 2 3
4
5 6 7