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

Execute ssis package with dtexec - sql server logging not writing events to database

I am using sql server data tools to create ssis packages to pull data from an AS400 to a sql 2012 express database. I am running windows 7, 64bit. I created the packages and setup logging to a text file and a sql server database within Visual Studio…
Andrew Corson
  • 93
  • 3
  • 11
0
votes
1 answer

How to explicitly specify the correct DTEXEC file when executing a SSIS package

I have an SSIS package created in visual studio 2010. I want to deploy the package to the file system(not into SQL Server) on the destination server. However, i have just been informed that the target server only has SQL Server 2005 installed. The…
StackTrace
  • 9,190
  • 36
  • 114
  • 202
0
votes
1 answer

dtexec error "The connection xxx is not found" with Project deployment model

When running DTEXEC I am getting "The connection xxxx is not found". I beleieve this is because the connection managers are located at Project level and not within the package itself. When running DTEXECUI - these connection managers are not…
user1079925
  • 541
  • 2
  • 8
  • 20
0
votes
2 answers

Advice on using Execute Process Task vs Execute Package Task in ssis

I have a parent pkg that calls a few child pkgs. For each child pkg I have a sql agent job that will override some Conenctions values as in dtexec, where you can use the handy /Conn[ection] to make the pkg configuring in a different way simply…
rio
  • 685
  • 9
  • 16
0
votes
1 answer

Bulk import multiple CSV using command line SSIS DTEXEC.exe

I have 200+ CSVs and I'd like to bulk insert it into SQL Server using SSIS command-line: DTEXEC.exe. Is this something that is possible to do with one command? I have to import hundreds of files daily automatically and I believe the most efficient…
sojim
  • 492
  • 2
  • 6
  • 19
-1
votes
1 answer

it doesnt throw error when it fails. I'm running it in SQL agent job

dtexec /SQL "\Export table" /SERVER svr1 /USER User1 /PASSWORD "*******" /CHECKPOINTING OFF /REPORTING E I also added this part "/Par "$ServerOption::SYNCHRONIZED(Boolean)";True" but it throws an error: Correct the script and reschedule the…
Shabir
  • 21
  • 1
-1
votes
1 answer

dtexec /val /proj my.ispac /pack my.dtsx /rep v 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 paths to the ispac and dtsx are longer. WHen I run…
user1443098
  • 6,487
  • 5
  • 38
  • 67
-1
votes
1 answer

DTExec: How to use a semicolon within a parameter value for SSIS package

I just learned from this stack overflow post that if parameters are not configured correctly (if you are missing a required parameter) when using DTExec to run a package from the command line, your package will forever be stuck in a "Created…
Michael Plautz
  • 3,578
  • 4
  • 27
  • 40
-1
votes
1 answer

dtexec /SET package variable value not being used by package

I'm using SQL Server 2012 & MS Visual Studio 2010 I have a DTS package with a user variable, PO (string), and I'm trying to execute a sql command using that variable, so I've set up another variable to build the sql string. The problem is, that when…
Dan
  • 3
  • 2
1 2 3 4 5 6
7