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

Is it possible to override a variable value calculated via an expression by passing a different value in the DTExec command line?

Is it possible to override the value of a variable in a SSIS package, which is calculated via an expression, by passing in a different value on the DTExec command line? I have a parameterized query and I'm passing variable User::StartDate into it. …
Simon Elms
  • 17,832
  • 21
  • 87
  • 103
0
votes
0 answers

Executing SSIS package using command prompt

I am trying to execute an SSIS package using command prompt. I have visual studio 2019 community edition installed and have selected 'Data storage and processing' during the installation. Also installed SQL server integration services projects from…
ASHISH A.S.
  • 3
  • 4
0
votes
1 answer

Executing SSIS Package from File System

We execute SSIS package using below command written in a batch file. (On premises MSSQL DB) D:\Program Files\Microsoft SQL Server\130\DTS\Binn\DTEXEC.exe>" "E:\Packages\SSISPKG1.dtsx" /Config "E:\Packages\Config\config.dtsConfig". Now we migrate to…
ArunKumar
  • 1
  • 1
0
votes
0 answers

Cannot find the file specified | SSIS | Execute Package SSIS using Dtexec on SQL Server

I have a doubt about Package SSIS. I am loading an information from an Excel file to a table on the SQL Server using SSIS. My file is on the Desktop and the package is successfully executed using Dtexec but nothing happens, if you change the file's…
Bruno Miguel
  • 1
0
votes
1 answer

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

We are moving an existing system from a SQL Server 2005 system. A component of that system was an SSIS project created with VS2005. We installed SQL Server 2016 STANDARD EDITION in January. The database data files are on the E: drive. We installed…
LindaK
  • 19
  • 1
  • 3
0
votes
0 answers

DTEXEC imported text file location

Does anybody know where the intermediate text file is stored by DTEXEC when it uses BULK INSERT for fast import the localy stored Excel file? As far as I know the BULK INSERT command can import only a text file, moreover, this text file must be…
Tomek
  • 31
  • 3
0
votes
0 answers

Error Running dtexec through command line with user input as variable

Hi Gys new to batching coding Need help in executing the below code.. dtexec /server .\DI02UAT /ISserver "\ssisdb\RiskVision\Sub_RiskVison_MKDBData\main.dstx" /Envreference 55 /par "$Serveroption::SYNCHRONIZED(Boolean)";True /Par…
Reyaansh K
  • 1
  • 1
0
votes
0 answers

Is there a tag I could add to a ".bat" file to stop command window being displayed

Is there a tag I could add to a ".bat" file so that the "CMD" window won't be displayed? "C:\Program Files (x86)\Microsoft SQL Server\120\DTS\Binn\dtexec.exe" /File "\\sqlbi3\Projects\SSIS\TechOne\AirlineBilling\AirlineBilling\PSE3_Report.dtsx" /SET…
DLallemant
  • 31
  • 4
0
votes
1 answer

problems running SSIS routine from command line

Can't run SSIS package from commend line tried all the locations of DTExec.exe on machine I have a basic SSIS package that reads files and loads into database. (runs fine from SSDT) tried the following command lines : "C:\Program Files…
huggy
  • 11
  • 1
  • 3
0
votes
0 answers

Cannot run ssis packages because 64-bit dtexec is not installed

I've been able to successfully create an ssis package (.dtsx) file using the SSMS 'import data' option and the VS 2017 SSIS toolbox (SQL Server 2017). The package itself works and it reads a csv file and loads it into a database table. Simple. This…
ghbcode
  • 61
  • 1
  • 6
0
votes
1 answer

How can i use dtsExec command in stored procedure to execute ssis package by passing entire configuration from a table?

I am using given command line to execute ssis packages in sp in sql server. SET @dtsExecCmd = @DTSEXECCMDPATH + ltrim(rtrim(@ssisPkgFilePath)) + '" /CONFIGFILE "' + ltrim(rtrim(@ssisCommonConfigPath)) + '"' EXEC @result = master..xp_cmdshell…
Raq
  • 433
  • 1
  • 7
  • 20
0
votes
2 answers

Bare Bones Setup to Run SSIS Package

I work with Microsoft Access 2016 with a SQL Server 2008 R2 backend. I have used SQL Server Management Studio to create some SSIS package for quick copying of data (right-click DB -> Tasks -> Import/Export). I was able to create a button in Access…
Michael Bruesch
  • 632
  • 7
  • 23
0
votes
1 answer

Issue with SSIS Package parameter - dtexec

I am trying to execute SSIS package using command line dtcexe but I am getting error. Error I get - Description: The package path referenced an object that cannot be found: "\Package.Variables[$Project::p_cityID].Properties[Value]". This occurs when…
Rohit
  • 1,520
  • 2
  • 17
  • 36
0
votes
1 answer

Appcrash Kernelbase.dll error when attempting to run SSIS package via DTExec.exe

I recently came across an issue while attempting to run a master parent SSIS package which calls several children packages. I haven't found a post with this exact issue, so I thought I'd share how I believe to have solved the issue. This is the…
daniness
  • 363
  • 1
  • 4
  • 21
0
votes
1 answer

DTEXEC doesn't trigger dtsx package in a power shell when triggered from java but works from command prompt on local machine

I'm calling a dtsx file in PowerShell(test.ps1) using below: & $dtexec /f "$dtsx" This works fine when I run the test.ps1 from command prompt in local machine but the same doesn't even trigger when test.ps1 is triggered from a java…
Maruthi
  • 1
1 2 3 4
5
6 7