{"id":19712,"date":"2022-10-24T07:37:00","date_gmt":"2022-10-24T05:37:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=19712"},"modified":"2022-12-19T13:34:32","modified_gmt":"2022-12-19T12:34:32","slug":"run-ssis-package-from-command-line","status":"publish","type":"post","link":"https:\/\/expert-only.com\/en\/ssis\/run-ssis-package-from-command-line\/","title":{"rendered":"Run an SSIS package from the command line using the DTExec utility"},"content":{"rendered":"\n<h4 class=\"has-text-align-center wp-block-heading\" id=\"h-integration-services-tutorial-to-run-ssis-packages-from-the-command-line-using-the-dtexec-utility\"><strong><em>Integration Services tutorial to run SSIS packages from the command line using the DTExec utility.<\/em><\/strong><\/h4>\n\n\n\n<p>The DTEXEC Integration Services tool allows users to run and configure an SSIS package from the command line. Indeed, the Microsoft SQL Server suite includes the DTExec.exe executable. This is a scripting tool for controlling and setting up SSIS packages. It is possible to launch the package execution utility from a command prompt, or from a batch file, i.e. with the .bat extension.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 ez-toc-wrap-center counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/expert-only.com\/en\/ssis\/run-ssis-package-from-command-line\/#1-prepare-the-ssis-package-to-execute-in-command-line\" >1. Prepare the SSIS package to execute in command line<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/expert-only.com\/en\/ssis\/run-ssis-package-from-command-line\/#2-how-to-run-ssis-packages-stored-in-a-folder-with-cmd\" >2. How to run SSIS packages stored in a folder with cmd ?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/expert-only.com\/en\/ssis\/run-ssis-package-from-command-line\/#3-how-to-fix-the-ssis-error-0xc001700a-for-incorrect-version\" >3. How to fix the SSIS error 0xC001700A for incorrect version ?<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/expert-only.com\/en\/ssis\/run-ssis-package-from-command-line\/#31-check-the-dtexec-active-version\" >3.1 Check the DTExec active version<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/expert-only.com\/en\/ssis\/run-ssis-package-from-command-line\/#32-check-the-sql-server-installation-version\" >3.2 Check the SQL Server installation version<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/expert-only.com\/en\/ssis\/run-ssis-package-from-command-line\/#33-check-the-compatibility-level-of-the-ssis-project-to-execute\" >3.3 Check the compatibility level of the SSIS project to execute<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/expert-only.com\/en\/ssis\/run-ssis-package-from-command-line\/#34-change-the-path-environment-variable-used-by-the-command-line\" >3.4 Change the PATH environment variable used by the command line<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/expert-only.com\/en\/ssis\/run-ssis-package-from-command-line\/#35-adapt-the-dtexec-version-to-match-the-ssis-project-compatibility\" >3.5 Adapt the DTExec version to match the SSIS project compatibility<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/expert-only.com\/en\/ssis\/run-ssis-package-from-command-line\/#4-run-the-ssis-package-with-the-dtexec-command\" >4. Run the SSIS package with the DTExec command<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/expert-only.com\/en\/ssis\/run-ssis-package-from-command-line\/#5-display-ssis-command-line-options-using-dtexec\" >5. Display SSIS command line options using DTEXEC<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/expert-only.com\/en\/ssis\/run-ssis-package-from-command-line\/#conclusion-on-running-ssis-packages-with-dtexec\" >Conclusion on running SSIS packages with DTExec<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1-prepare-the-ssis-package-to-execute-in-command-line\"><\/span>1. Prepare the SSIS package to execute in command line<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>To begin, open an MS-DOS command prompt through the Windows Start menu. Then click on Command Prompt. Or by typing cmd in the Windows search bar. Or a simple SSIS package found in this folder:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>C:\\ssis\\Package.dtsx<\/strong><\/li>\n<\/ul>\n\n\n\n<p>It is not necessary to run the dtexec.exe utility from the folder where the SSIS package is located. But the exact and absolute path to the DTSX file must be provided. Or the relative path from the folder where the command is located.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2-how-to-run-ssis-packages-stored-in-a-folder-with-cmd\"><\/span>2. How to run SSIS packages stored in a folder with cmd ?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>For example, type this command to run a package. This example runs the package with the default settings, i.e. it uses the configuration file (with a dtsconfig extension) by default.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"bat\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">DTEXEC \/FILE \"C:\\ssis\\Package.dtsx\"<\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"735\" height=\"722\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-execute-with-dtexec-1-run-package-command.jpg\" alt=\"Run an SSIS package from the command line with DTExec and error 0xC001700A\" class=\"wp-image-14715\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-execute-with-dtexec-1-run-package-command.jpg 735w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-execute-with-dtexec-1-run-package-command-300x295.jpg 300w\" sizes=\"auto, (max-width: 735px) 100vw, 735px\" \/><figcaption class=\"wp-element-caption\"><strong>Run an SSIS package from the command line with DTExec gives the 0xC001700A error<\/strong><\/figcaption><\/figure><\/div>\n\n\n<p>The following SSIS errors with 2 different codes may be displayed:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>SSIS Error Code: 0xC001700A<\/strong><\/li>\n\n\n\n<li>Source: Package<\/li>\n\n\n\n<li>Description: The version number in the package is not valid. The version number cannot be greater than current version number.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>SSIS error Code: 0xC0016020<\/strong><\/li>\n\n\n\n<li>Source: Package<\/li>\n\n\n\n<li>Description: Package migration from version 8 to version 6 failed with error 0xC001700A &#8220;The version number in the package is not valid. The version number cannot be greater than current version number.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-sql-and-it-tutorials wp-block-embed-sql-and-it-tutorials\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"EoDVIqy1W6\"><a href=\"https:\/\/expert-only.com\/en\/ssis\/import-xml-file-into-a-table-with-ssis\/\">Import an XML file into a SQL table with SSIS<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Import an XML file into a SQL table with SSIS&#8221; &#8212; SQL and IT Tutorials\" src=\"https:\/\/expert-only.com\/en\/ssis\/import-xml-file-into-a-table-with-ssis\/embed\/#?secret=BPla4zNz7x#?secret=EoDVIqy1W6\" data-secret=\"EoDVIqy1W6\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3-how-to-fix-the-ssis-error-0xc001700a-for-incorrect-version\"><\/span>3. How to fix the SSIS error 0xC001700A for incorrect version ?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>This aspect is depending on the configuration of 3 elements: the PC, the SQL Server, and the development environment. It is possible that multiple versions of the DTExec executable and the database engine coexist. The solution to correct the SSIS error code 0xC001700A is to change the SQL Server version used. To correct the error code, check the versions and compatibility levels of the following three items:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>The DTExec.exe utility.<\/li>\n\n\n\n<li>The SQL Server database engine.<\/li>\n\n\n\n<li>The compatibility level of the SSIS project.<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"31-check-the-dtexec-active-version\"><\/span>3.1 Check the DTExec active version<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>From the command prompt, type DTExec to display the detailed version number of the SSIS utility.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"bat\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">DTExec<\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"735\" height=\"278\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-execute-with-dtexec-2-check-dtexec-version-in-cmd.jpg\" alt=\"Check the version of the DTExec utility using the command line\" class=\"wp-image-14723\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-execute-with-dtexec-2-check-dtexec-version-in-cmd.jpg 735w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-execute-with-dtexec-2-check-dtexec-version-in-cmd-300x113.jpg 300w\" sizes=\"auto, (max-width: 735px) 100vw, 735px\" \/><figcaption class=\"wp-element-caption\">Check the version of the DTExec utility using the command line<\/figcaption><\/figure><\/div>\n\n\n<p><em>Microsoft (R) SQL Server Execute Package Utility<br>Version 11.0.7001.0 for 32-bit<\/em><\/p>\n\n\n\n<p>It is therefore version <strong>11.0.7001.0<\/strong> of the DTExec utility that is used. That is to say a version corresponding to SQL Server 2012, according to the <a href=\"https:\/\/learn.microsoft.com\/en-us\/troubleshoot\/sql\/releases\/download-and-install-latest-updates\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">list of SQL Server versions and updates available<\/a> on the official website.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"32-check-the-sql-server-installation-version\"><\/span>3.2 Check the SQL Server installation version<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>This check is not mandatory, but it is recommended to keep all blocks up to date. To do this, connect to the database with SSMS and run this <a href=\"https:\/\/expert-only.com\/en\/dba\/query-to-display-sql-server-version\/\">query to check the exact and detailed version of the SQL Server engine<\/a> used.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">select @@version as [SQL_Version];<\/pre>\n\n\n\n<p>The Microsoft <strong><em>SQL Server 2019 (RTM-GDR) 15.0.2095.3<\/em><\/strong> version is installed.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"680\" height=\"240\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-execute-with-dtexec-3-check-mssql-version-ssms.jpg\" alt=\"Check the version of the SQL Server database instance using SSMS\" class=\"wp-image-14731\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-execute-with-dtexec-3-check-mssql-version-ssms.jpg 680w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-execute-with-dtexec-3-check-mssql-version-ssms-300x106.jpg 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-execute-with-dtexec-3-check-mssql-version-ssms-678x240.jpg 678w\" sizes=\"auto, (max-width: 680px) 100vw, 680px\" \/><figcaption class=\"wp-element-caption\"><strong>Check the version of the SQL Server database instance using SSMS<\/strong><\/figcaption><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"33-check-the-compatibility-level-of-the-ssis-project-to-execute\"><\/span>3.3 Check the compatibility level of the SSIS project to execute<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Now check or modify the compatibility level of the SSIS package to be executed with DTExec. From Visual Studio 2019 for example, open the project containing the package to be executed.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Right-click on the SSIS project<\/strong> in Visual Studio.<\/li>\n\n\n\n<li>Display the <strong>project Properties<\/strong>.<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"680\" height=\"640\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-execute-with-dtexec-4-open-ssis-project-properties.jpg\" alt=\"Display the properties of an SSIS project from Visual Studio\" class=\"wp-image-14738\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-execute-with-dtexec-4-open-ssis-project-properties.jpg 680w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-execute-with-dtexec-4-open-ssis-project-properties-300x282.jpg 300w\" sizes=\"auto, (max-width: 680px) 100vw, 680px\" \/><figcaption class=\"wp-element-caption\"><strong>Display the SSIS project properties from Visual Studio 2019<\/strong><\/figcaption><\/figure><\/div>\n\n\n<p>Then check or change the <em>TargetServerVersion<\/em> property, which is the target compatibility level of the SSIS project being developed. With <a href=\"https:\/\/devopedia.org\/backward-compatibility\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">backward compatibility but not forward compatibility<\/a>, it is not possible to run a SQL Server 2019 package with the SQL Server 2012 version of DTExec. The reverse would be possible.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>From the <em>Project Properties Pages<\/em>.<\/li>\n\n\n\n<li>In the <em>Configuration Properties<\/em> tab and the <em>General<\/em> section, check and modify the target version to  <strong><em>SQL Server 2019<\/em><\/strong>, if necessary.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"780\" height=\"540\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-execute-with-dtexec-5-update-project-target-server-version.jpg\" alt=\"Changing the compatibility level of an SSIS project with TargetServerVersion\" class=\"wp-image-14754\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-execute-with-dtexec-5-update-project-target-server-version.jpg 780w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-execute-with-dtexec-5-update-project-target-server-version-300x208.jpg 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-execute-with-dtexec-5-update-project-target-server-version-768x532.jpg 768w\" sizes=\"auto, (max-width: 780px) 100vw, 780px\" \/><figcaption class=\"wp-element-caption\"><strong>Change the compatibility level of an SSIS project in TargetServerVersion property<\/strong><\/figcaption><\/figure><\/div>\n\n\n<p>After possibly changing the version, deploy the package again in the source folder before running it.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"34-change-the-path-environment-variable-used-by-the-command-line\"><\/span>3.4 Change the PATH environment variable used by the command line <span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>To change the version of the DT Exec software called from MS-DOS, display the PATH variable from a command line.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"bat\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">path<\/pre>\n\n\n\n<p>Here are the paths found in the PATH environment variable, directly from the MS-DOS Windows, and displayed online in the list using <a href=\"https:\/\/notepad-plus-plus.org\/\" target=\"_blank\" rel=\"noreferrer noopener\">Notepad++<\/a>.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"690\" height=\"445\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-execute-with-dtexec-6-display-path-variable-in-cmd.jpg\" alt=\"PATH environment variable with SQL Server paths used to run SSIS packages from command line\" class=\"wp-image-14774\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-execute-with-dtexec-6-display-path-variable-in-cmd.jpg 690w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-execute-with-dtexec-6-display-path-variable-in-cmd-300x193.jpg 300w\" sizes=\"auto, (max-width: 690px) 100vw, 690px\" \/><figcaption class=\"wp-element-caption\"><strong>PATH environment variable with SQL Server paths used to run SSIS packages from command line<\/strong><\/figcaption><\/figure><\/div>\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Windows paths with 32-bit MS SQL versions<\/strong>\n<ul class=\"wp-block-list\">\n<li><em>C:\\Program Files (x86)\\Microsoft SQL Server\\110\\DTS\\Binn\\; &#8211; SQL Server 2012 <strong>(active path)<\/strong><\/em><\/li>\n\n\n\n<li>C:\\Program Files (x86)\\Microsoft SQL Server\\120\\DTS\\Binn\\; &#8211; SQL Server 2014<\/li>\n\n\n\n<li>C:\\Program Files (x86)\\Microsoft SQL Server\\130\\DTS\\Binn\\; &#8211; SQL Server 2016<\/li>\n\n\n\n<li>C:\\Program Files (x86)\\Microsoft SQL Server\\140\\DTS\\Binn\\; &#8211; SQL Server 2017<\/li>\n\n\n\n<li><em>C:\\Program Files (x86)\\Microsoft SQL Server\\150\\DTS\\Binn\\; &#8211; SQL Server 2019 <strong>(path to use)<\/strong><\/em><\/li>\n\n\n\n<li>C:\\Program Files (x86)\\Microsoft SQL Server\\160\\DTS\\Binn\\; &#8211; SQL Server 2022<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Windows paths with 64-bit MS SQL versions<\/strong>\n<ul class=\"wp-block-list\">\n<li>C:\\Program Files\\Microsoft SQL Server\\<strong>150<\/strong>\\DTS\\Binn\\; \u2013 SQL Server 2019<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"35-adapt-the-dtexec-version-to-match-the-ssis-project-compatibility\"><\/span>3.5 Adapt the DTExec version to match the SSIS project compatibility<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Simply move the path to the 64-bit SQL Server 2019 folder before the other paths so that it is selected by default. To do this, follow these steps done with Windows 10:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Open Windows settings with the shortcut <strong><em>Windows + I<\/em><\/strong><\/li>\n\n\n\n<li>In the search bar, enter <strong><em>Variables<\/em><\/strong><\/li>\n\n\n\n<li>From the list of results, select <strong><em>Edit System Environment Variables<\/em><\/strong><\/li>\n\n\n\n<li>Then select <strong><em>Environment Variables<\/em><\/strong><\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"412\" height=\"468\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-execute-with-dtexec-7-open-windows-environment-variables.jpg\" alt=\"Edit environment variables from system properties with Windows 10\" class=\"wp-image-14781\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-execute-with-dtexec-7-open-windows-environment-variables.jpg 412w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-execute-with-dtexec-7-open-windows-environment-variables-264x300.jpg 264w\" sizes=\"auto, (max-width: 412px) 100vw, 412px\" \/><figcaption class=\"wp-element-caption\"><strong>Edit environment variables from system properties with Windows 10<\/strong><\/figcaption><\/figure><\/div>\n\n\n<p>To modify the contents of the environment variable, from this window, perform these actions:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Select the <strong><em>Path<\/em><\/strong> variable<\/li>\n\n\n\n<li>Choose the <strong><em>Edit<\/em><\/strong> option<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"618\" height=\"608\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-execute-with-dtexec-8-select-path-system-variable.jpg\" alt=\"Edit Windows Environment System variables from the System Properties menu\" class=\"wp-image-14789\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-execute-with-dtexec-8-select-path-system-variable.jpg 618w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-execute-with-dtexec-8-select-path-system-variable-300x295.jpg 300w\" sizes=\"auto, (max-width: 618px) 100vw, 618px\" \/><figcaption class=\"wp-element-caption\"><strong>Edit Windows Environment System variables from the System Properties menu<\/strong><\/figcaption><\/figure><\/div>\n\n\n<p>Change the order of the executables in the list. Indeed, for a given executable with the same name, Windows uses the first one in the list, sorted by default in alphabetical order.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Select the most recent version from the 32-bit folder, i.e. <strong>C:\\Program Files (x86)\\Microsoft SQL Server\\150\\DTS\\Binn\\;<\/strong><\/li>\n\n\n\n<li>Move the value up the list with the <strong><em>Move Up<\/em><\/strong> option, until it is the first of the SQL Server related paths.<\/li>\n<\/ul>\n\n\n\n<p class=\"has-text-align-center\"><strong>Reboot the PC to apply the changes made by the operating system.<\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"559\" height=\"501\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-execute-with-dtexec-9-move-up-sql-server-2019-path.jpg\" alt=\"Change the order of SQL Server executables in the Path environment variable\" class=\"wp-image-14801\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-execute-with-dtexec-9-move-up-sql-server-2019-path.jpg 559w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-execute-with-dtexec-9-move-up-sql-server-2019-path-300x269.jpg 300w\" sizes=\"auto, (max-width: 559px) 100vw, 559px\" \/><figcaption class=\"wp-element-caption\"><strong>Change the order of SQL Server executables in the Path environment variable<\/strong><\/figcaption><\/figure><\/div>\n\n\n<p>The DTExec utility is ready now to run using the same compatibility level as the package.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-sql-and-it-tutorials wp-block-embed-sql-and-it-tutorials\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"9BPeNZhhdr\"><a href=\"https:\/\/expert-only.com\/en\/ssis\/import-excel-file-into-sql-table-with-ssis\/\">Import an Excel file into a SQL table with SSIS<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Import an Excel file into a SQL table with SSIS&#8221; &#8212; SQL and IT Tutorials\" src=\"https:\/\/expert-only.com\/en\/ssis\/import-excel-file-into-sql-table-with-ssis\/embed\/#?secret=4biWOHvHX8#?secret=9BPeNZhhdr\" data-secret=\"9BPeNZhhdr\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"4-run-the-ssis-package-with-the-dtexec-command\"><\/span>4. Run the SSIS package with the DTExec command<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>After restarting the PC, type the DTExec command again from a DOS command prompt to check the new DTExec version. The window now shows <strong><em>15.0.2000.5<\/em><\/strong>.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"812\" height=\"518\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-execute-with-dtexec-10-check-version-after-reboot.jpg\" alt=\"Version of the cmd utility to run an SSIS package from the command line\" class=\"wp-image-14820\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-execute-with-dtexec-10-check-version-after-reboot.jpg 812w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-execute-with-dtexec-10-check-version-after-reboot-300x191.jpg 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-execute-with-dtexec-10-check-version-after-reboot-768x490.jpg 768w\" sizes=\"auto, (max-width: 812px) 100vw, 812px\" \/><figcaption class=\"wp-element-caption\"><strong>Version of the cmd utility to run an SSIS package from the command line<\/strong><\/figcaption><\/figure><\/div>\n\n\n<p>Finally, run the package again to check that it works properly, with the same command. The package is a very simple one that simply runs a SQL query to display the date using <a href=\"https:\/\/expert-only.com\/en\/ssis\/how-to-connect-to-sql-server-with-ssis\/\">an OLE DB connection to a MS SQL database<\/a>.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"bat\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">DTEXEC \/FILE \"C:\\ssis\\Package.dtsx\"<\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"812\" height=\"518\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-execute-with-dtexec-11-run-ssis-package-dtsx-success.jpg\" alt=\"\" class=\"wp-image-14830\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-execute-with-dtexec-11-run-ssis-package-dtsx-success.jpg 812w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-execute-with-dtexec-11-run-ssis-package-dtsx-success-300x191.jpg 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-execute-with-dtexec-11-run-ssis-package-dtsx-success-768x490.jpg 768w\" sizes=\"auto, (max-width: 812px) 100vw, 812px\" \/><figcaption class=\"wp-element-caption\"><strong>Successful execution of the SSIS Package.dtsx from the command line with DTExec<\/strong><\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"5-display-ssis-command-line-options-using-dtexec\"><\/span>5. Display SSIS command line options using DTEXEC<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Finally, it is possible to see the full list of command line options for the dtexec utility directly in MS-DOS. Display the DTEXEC command help by typing this script from a command line prompt.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"bat\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">DTEXEC \/?<\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"680\" height=\"721\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/ssis_dtexec_liste_options.png\" alt=\"List of all DTEXEC options to run an SSIS package from the command line\" class=\"wp-image-4595\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/ssis_dtexec_liste_options.png 680w, https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/ssis_dtexec_liste_options-283x300.png 283w\" sizes=\"auto, (max-width: 680px) 100vw, 680px\" \/><figcaption class=\"wp-element-caption\">List of all DTEXEC options to run an SSIS package from the command line<\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"conclusion-on-running-ssis-packages-with-dtexec\"><\/span>Conclusion on running SSIS packages with DTExec<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Finally, for more details, the official documentation of the dtexec utility is available. It is possible to manage other aspects of the Microsoft BI suite with scripts. Like deploying SSAS cubes with XMLA code or deploying SSRS reports with MS-DOS.<\/p>\n\n\n\n<p>Here is <a href=\"https:\/\/expert-only.com\/en\/ssis\/deploy-ssis-packages-with-cmd-and-dtutil\/\">how to deploy an SSIS package from the command line<\/a> using the MS-DOS prompt.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-sql-and-it-tutorials wp-block-embed-sql-and-it-tutorials\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"dI0LsMr3ND\"><a href=\"https:\/\/expert-only.com\/en\/ssis\/deploy-ssis-packages-with-cmd-and-dtutil\/\">Deploy SSIS packages with cmd and the dtutil tool<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Deploy SSIS packages with cmd and the dtutil tool&#8221; &#8212; SQL and IT Tutorials\" src=\"https:\/\/expert-only.com\/en\/ssis\/deploy-ssis-packages-with-cmd-and-dtutil\/embed\/#?secret=p83FuKi38I#?secret=dI0LsMr3ND\" data-secret=\"dI0LsMr3ND\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Integration Services tutorial to run SSIS packages from the command line using the DTExec utility. The DTEXEC Integration Services tool allows users to run and configure an SSIS package from the command line. Indeed, the Microsoft SQL Server suite <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/en\/ssis\/run-ssis-package-from-command-line\/\" title=\"Run an SSIS package from the command line using the DTExec utility\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10944,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[516],"tags":[412],"class_list":{"0":"post-19712","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-ssis","8":"tag-batch"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v26.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Run an SSIS package from the command line - DTExec - MS BI<\/title>\n<meta name=\"description\" content=\"To run an SSIS package from the MS-DOS command line, use the DTExec command, this utility also allows you to configure DSTX packages.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/expert-only.com\/en\/ssis\/run-ssis-package-from-command-line\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Run an SSIS package from the command line using the DTExec utility\" \/>\n<meta property=\"og:description\" content=\"To run an SSIS package from the MS-DOS command line, use the DTExec command, this utility also allows you to configure DSTX packages.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/en\/ssis\/run-ssis-package-from-command-line\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL and IT Tutorials\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-24T05:37:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-19T12:34:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/work-DE8FCB57747_1920x1080.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Expert-Only\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@expert_only\" \/>\n<meta name=\"twitter:site\" content=\"@expert_only\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Expert-Only\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"10 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/run-ssis-package-from-command-line\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/run-ssis-package-from-command-line\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Run an SSIS package from the command line using the DTExec utility\",\"datePublished\":\"2022-10-24T05:37:00+00:00\",\"dateModified\":\"2022-12-19T12:34:32+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/run-ssis-package-from-command-line\/\"},\"wordCount\":1341,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/en\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/run-ssis-package-from-command-line\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/work-DE8FCB57747_1920x1080.jpg\",\"keywords\":[\"Batch\"],\"articleSection\":[\"SSIS\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/en\/ssis\/run-ssis-package-from-command-line\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/run-ssis-package-from-command-line\/\",\"url\":\"https:\/\/expert-only.com\/en\/ssis\/run-ssis-package-from-command-line\/\",\"name\":\"Run an SSIS package from the command line - DTExec - MS BI\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/run-ssis-package-from-command-line\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/run-ssis-package-from-command-line\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/work-DE8FCB57747_1920x1080.jpg\",\"datePublished\":\"2022-10-24T05:37:00+00:00\",\"dateModified\":\"2022-12-19T12:34:32+00:00\",\"description\":\"To run an SSIS package from the MS-DOS command line, use the DTExec command, this utility also allows you to configure DSTX packages.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/run-ssis-package-from-command-line\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/en\/ssis\/run-ssis-package-from-command-line\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/run-ssis-package-from-command-line\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/work-DE8FCB57747_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/work-DE8FCB57747_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/run-ssis-package-from-command-line\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"en\",\"item\":\"https:\/\/expert-only.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Run an SSIS package from the command line using the DTExec utility\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/en\/#website\",\"url\":\"https:\/\/expert-only.com\/en\/\",\"name\":\"SQL and IT Tutorials\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/en\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"width\":381,\"height\":174,\"caption\":\"Expert-Only\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\",\"https:\/\/x.com\/expert_only\",\"https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"caption\":\"Expert-Only\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Run an SSIS package from the command line - DTExec - MS BI","description":"To run an SSIS package from the MS-DOS command line, use the DTExec command, this utility also allows you to configure DSTX packages.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/expert-only.com\/en\/ssis\/run-ssis-package-from-command-line\/","og_locale":"en_US","og_type":"article","og_title":"Run an SSIS package from the command line using the DTExec utility","og_description":"To run an SSIS package from the MS-DOS command line, use the DTExec command, this utility also allows you to configure DSTX packages.","og_url":"https:\/\/expert-only.com\/en\/ssis\/run-ssis-package-from-command-line\/","og_site_name":"SQL and IT Tutorials","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2022-10-24T05:37:00+00:00","article_modified_time":"2022-12-19T12:34:32+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/work-DE8FCB57747_1920x1080.jpg","type":"image\/jpeg"}],"author":"Expert-Only","twitter_card":"summary_large_image","twitter_creator":"@expert_only","twitter_site":"@expert_only","twitter_misc":{"Written by":"Expert-Only","Est. reading time":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/en\/ssis\/run-ssis-package-from-command-line\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/ssis\/run-ssis-package-from-command-line\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Run an SSIS package from the command line using the DTExec utility","datePublished":"2022-10-24T05:37:00+00:00","dateModified":"2022-12-19T12:34:32+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/en\/ssis\/run-ssis-package-from-command-line\/"},"wordCount":1341,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/en\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/en\/ssis\/run-ssis-package-from-command-line\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/work-DE8FCB57747_1920x1080.jpg","keywords":["Batch"],"articleSection":["SSIS"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/en\/ssis\/run-ssis-package-from-command-line\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/en\/ssis\/run-ssis-package-from-command-line\/","url":"https:\/\/expert-only.com\/en\/ssis\/run-ssis-package-from-command-line\/","name":"Run an SSIS package from the command line - DTExec - MS BI","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/en\/ssis\/run-ssis-package-from-command-line\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/en\/ssis\/run-ssis-package-from-command-line\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/work-DE8FCB57747_1920x1080.jpg","datePublished":"2022-10-24T05:37:00+00:00","dateModified":"2022-12-19T12:34:32+00:00","description":"To run an SSIS package from the MS-DOS command line, use the DTExec command, this utility also allows you to configure DSTX packages.","breadcrumb":{"@id":"https:\/\/expert-only.com\/en\/ssis\/run-ssis-package-from-command-line\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/en\/ssis\/run-ssis-package-from-command-line\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/ssis\/run-ssis-package-from-command-line\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/work-DE8FCB57747_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/work-DE8FCB57747_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/en\/ssis\/run-ssis-package-from-command-line\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"en","item":"https:\/\/expert-only.com\/en\/"},{"@type":"ListItem","position":2,"name":"Run an SSIS package from the command line using the DTExec utility"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/en\/#website","url":"https:\/\/expert-only.com\/en\/","name":"SQL and IT Tutorials","description":"","publisher":{"@id":"https:\/\/expert-only.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/en\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","width":381,"height":174,"caption":"Expert-Only"},"image":{"@id":"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ExpertOnlyCom\/","https:\/\/x.com\/expert_only","https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA"]},{"@type":"Person","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","caption":"Expert-Only"}}]}},"_links":{"self":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/19712","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/comments?post=19712"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/19712\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media\/10944"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media?parent=19712"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/categories?post=19712"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/tags?post=19712"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}