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

Command line SSIS (DTEXEC) with Proxy account

I know we can start an SSIS package from DTExec. And when we define an SSIS job in SQL Agent, I can change the Run As to be a pre-defined Proxy account. Now, can I run an SSIS package from DTExec, using a Credential(Proxy) account, in a batch file?…
Al__H
  • 196
  • 4
  • 16
1
vote
1 answer

SSIS' DtExec 32bit vs 64bit Confusion

this question has been asked before in different flavours, but I cant find a satisfactory answer. We are an MS based shop and we have plenty of SQL 2016 databases. We also use SSIS 2016 a lot and in my area we exclusively use the catalog (SSISDB)…
CalleWirsch
  • 95
  • 9
1
vote
0 answers

Not able to get error code and description in Dtexec /ISServer command in SQL Server 2019

I'm running a SSIS package which is developed in Visual Studio 2019 using dtexec command given below. We are using SQL Server Management Studio 2019 version. Packages are deployed to Integration Services Catalogs. DTEXEC /ISSERVER…
Rithu
  • 11
  • 2
1
vote
1 answer

Run DTEXEC from SSMS to run SSIS Catalog Package

I would like to execute SSIS package using Catalog in a stored procedure using DTEXEC: DECLARE @cmd varchar(8000) DECLARE @params varchar(4000) SELECT @params = '/SET \Package.Variables[User::VarBigInt].Properties[Value];"' + CONVERT(char(10),…
Anonymous
  • 63
  • 1
  • 5
1
vote
0 answers

could not create dts.application because of error 0x80040154 dtexec error in SSIS

Should the SSIS package execution work with dtexec.exe without installing integration services or SQL server?
Bidy Ray
  • 21
  • 4
1
vote
1 answer

SSIS Package Failing when called through DTExec - fine through VS

I have an SSIS package that is running fine when I press the "Start" button in VS, but when I run it via DTExec, it's bombing part way through with the following errors. Error: 2020-06-10 13:47:20.22 Code: 0xC0047038 Source: JCMAST to SQL…
mick_swartz
  • 21
  • 6
1
vote
2 answers

Console application execute Dtsx file with error -1073679321

My code have not a problem. I know that because to console application don't execute only in my machine. Basically I load the package and after execute. I tried: Execute Visual studio as Administrator; Install all features of the Microsoft SQL…
Willimar
  • 61
  • 9
1
vote
1 answer

How to run SSIS package with password in Windows Scheduler?

I have an SSIS package that has the ProtectionLevel=EncryptSensitiveWithPassword and would like to run this project .dtsx file from the Windows Task Scheduler (on MS Windows Server 2012). In the task scheduler, trying to run... "C:\Program Files…
lampShadesDrifter
  • 3,925
  • 8
  • 40
  • 102
1
vote
1 answer

SQL Server 2016 : Error running DTS package using dtexec from cmd line to export from table to flat file

I have the following software: Microsoft SQL Server 2016 Windows Server 2016 Datacenter SQL Server Management Studio v18.2 (SSMS) Running services: C:\workspace> net start | grep -i sql SQL Full-text Filter Daemon Launcher (MSSQLSERVER) SQL…
user3737906
  • 89
  • 1
  • 9
1
vote
1 answer

The term 'EXEC' is not recognized as the name of a cmdlet Powershell

I have an SSIS dtsx package that I want to run using PowerShell. Below is what I am running in powershell. EXEC xp_cmdshell '"C:\Program Files\Microsoft SQL Server\130\DTS\Binn\DTExec.exe" /f "F:\SqlExport\New package.dtsx"' Unfortunately I get the…
imba22
  • 651
  • 1
  • 13
  • 25
1
vote
1 answer

How to create a transaction log on WinSCP on SSIS package

I have SSIS package, which uses winscp to execute some commands in a text file to upload files to a FTP site. I use DTExec.exe to execute this SSIS package. Right now, I need to show winscp FTP log including display file name uploaded on FTP site.…
user1188125
  • 677
  • 2
  • 13
  • 21
1
vote
1 answer

SSIS Script Task not working when called through dtexec

I am Currently using the visual studio 2015 in which my script task runs fine. When i tried to run the same package using DTEXEC util using the command C:\Program Files (x86)\Microsoft SQL Server\120\DTS\Binn\DTExec.exe" /f "filepath" I am…
aswin
  • 23
  • 9
1
vote
0 answers

Execute SSIS package remotely via DTExec: ForEach loop file enumerator is empty

curly one for SSIS / Windows / Powershell people. I have an issue where I have two Windows 2012 servers and I'm trying to remotely execute an SSIS package. Server "D3" is the SQL server database with SSIS installed, and I am able to execute my…
marcus
  • 11
  • 2
1
vote
1 answer

DTExec.exe CheckFile and Validate fails

I'm trying to execute a dtsx script using DTExec.exe as part of the batch process. The following command line script works: "C:\Program Files\Microsoft SQL Server\130\DTS\Binn\DTExec.exe" -File "\\\\vm-to-somewhere\d$\Projects\test.dtsx" However,…
weiji14
  • 477
  • 7
  • 14
1
vote
1 answer

Process.Start application was unable to start correctly w/ DTExec

I am writing a tool that allows a DBA to remotely run an SSIS package. The application is an XBAP and has been deployed to a SQL Server, with the SSIS package on the same server. I achieve the remote calling of the SSIS package by running DTExec…
Aserian
  • 1,047
  • 1
  • 15
  • 31
1 2
3
4 5 6 7