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

Passing parameters to a package from command prompt

I have a ssis package "pkg1" with a variable "var1" which I pass a parameter to it from the command prompt such as dtexec.exe /f c:\pkg1.dtsx /set \Package.Variables[User::var1].Properties[Value];"test" In the packages I have a script task which I…
Arman S
  • 65
  • 2
  • 6
2
votes
1 answer

PowerShell DTexec /ISServer pass a connectionstring as package variable

I want to execute a SSIS package on ISServer via PowerShell. I used the script found on microsoft page. This doesn't work out for me. I want to pass a connectionstring but not to assign to the connectionmanager but just as a variable string. In…
Lapken
  • 21
  • 1
2
votes
1 answer

DTExec returns The package path referenced an object that cannot be found

I have a SSIS package and am trying to execute it using DTExec.exe My command is this: DTExec /F \\SERVERNAME\CUBEDAILYBACKUP.DTSX /MAXCONCURRENT "-1" /CHECKPOINTING OFF /REPORTING EWCPI /CONSOLELOG SMT /SET…
user7577311
2
votes
1 answer

SSIS dtexec - The component is missing, not registered, not upgradable, or missing required interfaces

I have a fairly simple control flow with two data flows. The first one reads data from an Excel spreadsheet using a source script component and stores data into a cache transform component. The second data flow uses a source script component to read…
Rubio
  • 1,067
  • 1
  • 14
  • 25
2
votes
0 answers

SSIS package creates tables on the wrong database

This issue occurred and I would like to know possible causes: During text file import the SSIS package created tables in the wrong database instead of writing in the correct tables in the correct database. Details: There is an application which uses…
Aris Glykas
  • 21
  • 3
2
votes
1 answer

Executing a SSIS package that references mso.dll with DTEXEC

Apologies if this has been answered, but I've not been able to find an answer that solves my issue. I have a SSIS package that has a script task which references: C:\Program Files (x86)\Common Files\microsoft shared\OFFICE16\MSO.DLL. When executed…
Ian Mitchell
  • 83
  • 1
  • 7
2
votes
2 answers

SSIS package failure when executed in windows task schedule

I have three SSIS packages to sync data from SharePoint to SQL Server, I have put them in task schedule to run daily, but one or two of them failure sometimes. The error message from task schedule is action "C:\Program Files\Microsoft SQL…
Sven
  • 79
  • 10
2
votes
0 answers

dtexec.exe /SET won't recognize the Property Path

I have a SSIS package set up for a data export that we regularly do, which I have no problem running in Visual Studio, but which is giving problems when I try to use the command line to execute it while using /SET to change variables (If I use the…
GeoLawton
  • 21
  • 3
2
votes
1 answer

SSIS: Stop SSIS package execution if any files missing

I have a SSIS package which look for 8 files in a pre-defined location. Using script task I am checking if any files are missing? If any files are missing then I send an email stating files are missing. Now I want to stop the current package if any…
Masud Ahmed
  • 21
  • 5
2
votes
1 answer

SSIS Deploying Expression variables

I am planning to deploy a SSIS package on the production server using the command line prompt. I am executing the following : DTEXEC.exe /FILE "C:\SSISPackages\Rewards\ExcelMasterToRewardsExcel.dtsx" /DECRYPT ssis …
Subodh Shetty
  • 204
  • 2
  • 12
2
votes
2 answers

LoadFromSQLServer method has encountered OLE DB

I have this error: LoadFromSQLServer method has encountered OLE DB error code 0x80004005 (Login timeout expired). The SQL statement that was issued has failed And here is my code, what is wrong? DECLARE @FileName VARCHAR(50); DECLARE @VendorID…
user1653113
  • 21
  • 1
  • 1
  • 3
1
vote
1 answer

SSIS package working in BIDS but not with DTEXEC, error DTS_E_ADODESTFAILEDTOACQUIRECONNECTION

I have build an SSIS package which is working well within BIDS. The package runs successfully. I'm now trying to execute the same package, with the same config from the command line, but it fails to acquire a connection (error 0xC0208452 :…
Steve B
  • 36,818
  • 21
  • 101
  • 174
1
vote
1 answer

DTEXEC override of connection string is not working

We have many SSIS packages stored on a network drive. Every package has a connection manager called config_connection and all the package configurations are stored in a database that config_connection manager points to. On execution we would like…
Bee_Riii
  • 814
  • 8
  • 26
1
vote
0 answers

How to migrate .dtsx package which executes python script to SSIS Linux using dtexec?

I am migrating SSIS ETL from Windows to Linux and using dtexec. In Windows, the executables can be added as ...python.exe. I would like to know how the same can be migrated to Linux as python3 will be present in /usr/bin/python3. I have tried adding…
Shanthini
  • 21
  • 3
1
vote
0 answers

VBS DTEXEC - SSIS Package fails to fully execute before continuing on

I have a vbs script that's failing to finish loading a file before moving on to the next steps. I've been using this code for 2+ years so this is likely due to my poor code and error handling - If the SSIS package fails to fully load, the procedure…
Mike
  • 133
  • 1
  • 1
  • 13
1
2
3 4 5 6 7