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
0
votes
2 answers

DTExec reporting only Data Flow task

In Windows 7 I want to schedule the execution of some DTSX packages. What I've done is to make a CMD file for each DTSX package, and schedule them with Windows Scheduler. Starting from this article, I write the following code for my CMD files: @ECHO…
Nicolaesse
  • 2,554
  • 12
  • 46
  • 71
0
votes
0 answers

SSIS package skips the last row

This question was asked here. SSIS Package not reading the last row in flat file I believe I have some extra perspective on it. I have a SSIS package that does simple data flow task which loads Flat file to Sql Server. The file has a Header, 5000…
Rabin
  • 418
  • 3
  • 13
0
votes
0 answers

SSIS error when executing the package via Control-M or DTExec

So I have created an SSIS package that reads file from a remote directory and load everything it reads into a SQL table. It works fine in my machine even in the test environment but when I deployed it to production environment everything fails. I…
user3068888
  • 51
  • 1
  • 1
  • 9
0
votes
0 answers

What's the privileges of an account under windows task schedule?

I use dtexec to run ssis packages and I use the dtexec...>e:\log.txt command to write console messages to a txt file. It works fine if I run it manually, but it is not working if I put it in task schedule. It seems no permission to create the…
Sven
  • 79
  • 10
0
votes
1 answer

sqldumper error when trying to run dtexec with project deployment model

I have a SSIS project with several packages which uses the Project deployment model, which means that there are project level parameters and connections. Beacuse of this reason, to execute the packages using dtexec, it's necessary to use two…
JotaBe
  • 38,030
  • 8
  • 98
  • 117
0
votes
1 answer

SSIS 2016 VS 2015 Error 0xC001700A Version number in the package is not valid. he version number cannot be greater than current version number

I upgraded an SSIS 2008R2 package to SSIS 2016 using the upgrade wizard. It upgraded successfully. I do have both 2008R2 and 2016 SQL Server loaded on my server. I am executing a batch file that calls the upgraded package. The batch file is…
Laurie
  • 9
  • 2
0
votes
0 answers

Can SSIS packages access the network when launched from DTExec?

I have an SSIS package that pulls some data out of SQL Server into a .csv file, then copies the file to a network location (uses Robocopy). Runs fine as a SQL Agent job. When I use DtExec from my own machine, Robocopy fails with 'Access is…
The other other Alan
  • 1,868
  • 12
  • 21
0
votes
1 answer

SSIS package runs when executed manually on server, but fails when run from Command Line (dtexec)

I am having trouble implementing the execution of a SSIS package via the command line utility dtexec. I am implementing this process on a SQL 2012 server (64 bit) with Integration Services and Business Intelligence Development Studio (VS). The…
Andrew Overton
  • 65
  • 1
  • 8
0
votes
1 answer

Failed to open package file due to error 0x800070035

Full error message: Could not load package "\\File.dtsx" because of error 0xC0011002. Description: Failed to open package file "\\File" due to error 0x80070035 "The network path was not found.". This occurs when loading a package and the file…
Andrew Kilburn
  • 2,251
  • 6
  • 33
  • 65
0
votes
1 answer

DTexec: The package execution returned DTSER_FAILURE (1)

I have a package in SSIS and is getting an error when I try to run it by .bat file (when I run from a SSIS solution this errors never comes). The error: Description: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded,…
dreTa
  • 27
  • 1
  • 3
0
votes
0 answers

Calling DTExec From Code doesn't work, but command prompt does

I'm writing an application that runs DTExec as another user to run an SSIS package that has been deployed to a server. Currently, I generate the argument string based on whether or not certain components are enabled. Here's my issue... When running…
Aserian
  • 1,047
  • 1
  • 15
  • 31
0
votes
1 answer

How can I remote run an SSIS package using DTEXEC?

I'm very new to using dtexec and to deploying SSIS packages (mostly just run them in VS). I would like to remote run a package that I have deployed to a server using DTEXEC... The package name is SQL2012 Update Run. When I open up SSMS, the…
Aserian
  • 1,047
  • 1
  • 15
  • 31
0
votes
1 answer

Can't execute command when run as a child batch

In a "child.cmd" file, I have the following command: DTEXEC.EXE /FILE "\"%~dp0..\SSIS Packages\%stepName%.dtsx\"" /CONNECTION DestinationConnectionOLEDB;"\"Data Source=%serverName%;Initial…
Andrew
  • 11
  • 4
0
votes
1 answer

SSIS Package not running from code

I am attempting to run an SSIS package from a website using the following code: Process process = new Process(); try { process.StartInfo.UseShellExecute = false; process.StartInfo.RedirectStandardOutput =…
Anglefroghammer
  • 238
  • 2
  • 15
0
votes
1 answer

Syntax to dtexec multiple SSIS packages

What is the syntax for calling multiple SSIS packages (Package1, Package2, Package3) using dtexec in a bat file? dtexec /f "C:\Package1.dtsx"
Teng
  • 59
  • 1
  • 2
1 2 3 4 5
6
7