{"id":17531,"date":"2022-11-02T07:23:00","date_gmt":"2022-11-02T06:23:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=17531"},"modified":"2023-01-31T12:22:14","modified_gmt":"2023-01-31T11:22:14","slug":"deploy-ssis-packages-with-cmd-and-dtutil","status":"publish","type":"post","link":"https:\/\/expert-only.com\/en\/ssis\/deploy-ssis-packages-with-cmd-and-dtutil\/","title":{"rendered":"Deploy SSIS packages with cmd and the dtutil tool"},"content":{"rendered":"\n<h4 class=\"has-text-align-center wp-block-heading\" id=\"h-how-to-deploy-ssis-packages-with-the-cmd-command-line-and-the-dtutil-tool\"><strong><em>How to deploy SSIS packages with the cmd command line and the dtutil tool?<\/em><\/strong><\/h4>\n\n\n\n<p>To deploy SSIS packages with cmd, SQL Server includes the dtutil executable utility that works with cmd command lines, to deploy dtsx files directly with ms-dos. Dtutil.exe is a good choice for scripting and automating the deployment of SSIS projects. It can be run from a command prompt or from a batch file (.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\/deploy-ssis-packages-with-cmd-and-dtutil\/#1-methods-to-deploy-ssis-packages\" >1. Methods to deploy SSIS packages<\/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\/deploy-ssis-packages-with-cmd-and-dtutil\/#2-copy-ssis-packages-with-dtutil\" >2. Copy SSIS packages with DTUTIL<\/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\/deploy-ssis-packages-with-cmd-and-dtutil\/#3-deploy-dtsx-files-to-the-ssis-package-store-with-cmd\" >3. Deploy dtsx files to the SSIS package store with cmd<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/expert-only.com\/en\/ssis\/deploy-ssis-packages-with-cmd-and-dtutil\/#4-dtutil-example-to-deploy-a-package-to-sql-server\" >4. Dtutil example to deploy a package to SQL Server<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/expert-only.com\/en\/ssis\/deploy-ssis-packages-with-cmd-and-dtutil\/#41-deploy-to-the-default-mssqlserver-instance\" >4.1 Deploy to the default MSSQLSERVER instance<\/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\/deploy-ssis-packages-with-cmd-and-dtutil\/#42-deploy-to-a-specific-or-named-instance\" >4.2 Deploy to a specific or named instance<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/expert-only.com\/en\/ssis\/deploy-ssis-packages-with-cmd-and-dtutil\/#5-use-azure-devops-to-automate-deployment\" >5. Use Azure DevOps to automate deployment<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1-methods-to-deploy-ssis-packages\"><\/span>1. Methods to deploy SSIS packages<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>What are the different methods for deploying an Integration Services package? The following examples show how to deploy the <em>Package-Budget.dtsx<\/em> package to the Windows file system, the SSIS package store and MS SQL Server. To deploy SSIS packages to or from Windows, you can use one of three alternatives, a simple copy.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><a href=\"https:\/\/expert-only.com\/en\/ms-dos\/copy-windows-files-with-cmd\/\">The MS-DOS copy command<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/expert-only.com\/en\/powershell\/copy-a-file-with-windows-powershell\/\">The PowerShell Copy-Item command<\/a><\/li>\n\n\n\n<li>or directly with the <strong><em>Windows Explorer<\/em><\/strong><\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2-copy-ssis-packages-with-dtutil\"><\/span>2. Copy SSIS packages with DTUTIL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>In this tutorial, the <em>dtutil command method<\/em>, on a single line, is used. Replace the C:\\temp path with the target project folder. To begin, open a cmd command prompt and access a project, for example, in the folder containing the packages to deploy.<\/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=\"\">DTUTIL \/FILE Package-Budget.dtsx \/COPY FILE;C:\\temp\\Package-Budget.dtsx<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3-deploy-dtsx-files-to-the-ssis-package-store-with-cmd\"><\/span>3. Deploy dtsx files to the SSIS package store with cmd<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>To deploy an SSIS file into the package store, type the following command on a single 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=\"\">DTUTIL \/FILE Package-Budget.dtsx \/COPY DTS;Package-Budget.dtsx<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"4-dtutil-example-to-deploy-a-package-to-sql-server\"><\/span>4. Dtutil example to deploy a package to SQL Server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>To deploy to SQL Server directly, type the following command, always on a single line.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"41-deploy-to-the-default-mssqlserver-instance\"><\/span>4.1 Deploy to the default MSSQLSERVER instance<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>The command below deploys the example package on the default SQL Server instance and on the local machine. Indeed, no machine name is specified as a parameter.<\/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=\"\">DTUTIL \/FILE Package-Budget.dtsx \/COPY SQL;Package-Budget<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"42-deploy-to-a-specific-or-named-instance\"><\/span>4.2 Deploy to a specific or named instance<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>To deploy to another SQL Server, or another locally <a href=\"https:\/\/expert-only.com\/en\/dba\/install-second-instance\/\">named SQL Server instance<\/a>, add a parameter to the command line. And specify the destination server, in this form <strong><em>\/DESTSERVER &#8220;SERVER INSTANCE-NAME&#8221;<\/em><\/strong>.<\/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=\"\">DTUTIL \/FILE Package-Budget.dtsx \/DestServer \"SERVER\\INSTANCE-NAME\" \/COPY SQL;Package-Budget<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"5-use-azure-devops-to-automate-deployment\"><\/span>5. Use Azure DevOps to automate deployment<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>On the other hand, it is easy to schedule operations to <a href=\"https:\/\/expert-only.com\/en\/ssis\/import-multiple-text-files-with-ssis\/\">load CSV files with SSIS<\/a> using the SQL Server Agent for example. It is important to <a href=\"https:\/\/www.redhat.com\/en\/topics\/automation\/what-is-devops-automation\" target=\"_blank\" rel=\"noreferrer noopener\">automate the deployment of files and new projects releases<\/a> as much as possible, to avoid errors and regressions. Today, with <a href=\"https:\/\/azure.microsoft.com\/en-us\/products\/devops\/#overview\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">Azure DevOps<\/a>, this automation is becoming more and more widespread.<\/p>\n\n\n\n<p>Indeed, it is possible to use simple methods to deploy an SSIS package from a simple copy in a cmd or PowerShell file. But also, with manual deployments from dtutil or Visual Studio which also tend to disappear. In favour of continuous development and integration methods such as Azure DevOps.<\/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=\"zFoeiGeoSo\"><a href=\"https:\/\/expert-only.com\/en\/ssis\/install-ssis-in-visual-studio-2019\/\">How to install SSIS in Visual Studio 2019? SQL Server Integration Services<\/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;How to install SSIS in Visual Studio 2019? SQL Server Integration Services&#8221; &#8212; SQL and IT Tutorials\" src=\"https:\/\/expert-only.com\/en\/ssis\/install-ssis-in-visual-studio-2019\/embed\/#?secret=HQtIngGKOK#?secret=zFoeiGeoSo\" data-secret=\"zFoeiGeoSo\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">Tutorials for developing and managing SSIS packages<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/expert-only.com\/en\/ssis\/zip-files-with-ssis\/\">Tutorial to zip files with SSIS and 7zip<\/a>.<\/li>\n\n\n\n<li><a href=\"https:\/\/expert-only.com\/en\/ssis\/import-xml-file-into-a-table-with-ssis\/\">Tutorial to import an XML document into a SQL table with SSIS.<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/expert-only.com\/en\/ssis\/aggregate-data-with-ssis\/\">How to aggregate data with SSIS ?<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>How to deploy SSIS packages with the cmd command line and the dtutil tool? To deploy SSIS packages with cmd, SQL Server includes the dtutil executable utility that works with cmd command lines, to deploy dtsx files directly with <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/en\/ssis\/deploy-ssis-packages-with-cmd-and-dtutil\/\" title=\"Deploy SSIS packages with cmd and the dtutil tool\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":6117,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[516],"tags":[],"class_list":{"0":"post-17531","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-ssis"},"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>Deploy SSIS packages with cmd - Dtutil utility - MS BI<\/title>\n<meta name=\"description\" content=\"Deploy SSIS packages with cmd to a SQL Server, a file system or the package store using the dedicated dtutil command line tool.\" \/>\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\/deploy-ssis-packages-with-cmd-and-dtutil\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Deploy SSIS packages with cmd and the dtutil tool\" \/>\n<meta property=\"og:description\" content=\"Deploy SSIS packages with cmd to a SQL Server, a file system or the package store using the dedicated dtutil command line tool.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/en\/ssis\/deploy-ssis-packages-with-cmd-and-dtutil\/\" \/>\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-11-02T06:23:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-01-31T11:22:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/city-lights-8AD7D1A8877_1920x1080.jpeg\" \/>\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=\"3 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\/deploy-ssis-packages-with-cmd-and-dtutil\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/deploy-ssis-packages-with-cmd-and-dtutil\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Deploy SSIS packages with cmd and the dtutil tool\",\"datePublished\":\"2022-11-02T06:23:00+00:00\",\"dateModified\":\"2023-01-31T11:22:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/deploy-ssis-packages-with-cmd-and-dtutil\/\"},\"wordCount\":474,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/en\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/deploy-ssis-packages-with-cmd-and-dtutil\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/city-lights-8AD7D1A8877_1920x1080.jpeg\",\"articleSection\":[\"SSIS\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/en\/ssis\/deploy-ssis-packages-with-cmd-and-dtutil\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/deploy-ssis-packages-with-cmd-and-dtutil\/\",\"url\":\"https:\/\/expert-only.com\/en\/ssis\/deploy-ssis-packages-with-cmd-and-dtutil\/\",\"name\":\"Deploy SSIS packages with cmd - Dtutil utility - MS BI\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/deploy-ssis-packages-with-cmd-and-dtutil\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/deploy-ssis-packages-with-cmd-and-dtutil\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/city-lights-8AD7D1A8877_1920x1080.jpeg\",\"datePublished\":\"2022-11-02T06:23:00+00:00\",\"dateModified\":\"2023-01-31T11:22:14+00:00\",\"description\":\"Deploy SSIS packages with cmd to a SQL Server, a file system or the package store using the dedicated dtutil command line tool.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/deploy-ssis-packages-with-cmd-and-dtutil\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/en\/ssis\/deploy-ssis-packages-with-cmd-and-dtutil\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/deploy-ssis-packages-with-cmd-and-dtutil\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/city-lights-8AD7D1A8877_1920x1080.jpeg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/city-lights-8AD7D1A8877_1920x1080.jpeg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/deploy-ssis-packages-with-cmd-and-dtutil\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"en\",\"item\":\"https:\/\/expert-only.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Deploy SSIS packages with cmd and the dtutil tool\"}]},{\"@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":"Deploy SSIS packages with cmd - Dtutil utility - MS BI","description":"Deploy SSIS packages with cmd to a SQL Server, a file system or the package store using the dedicated dtutil command line tool.","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\/deploy-ssis-packages-with-cmd-and-dtutil\/","og_locale":"en_US","og_type":"article","og_title":"Deploy SSIS packages with cmd and the dtutil tool","og_description":"Deploy SSIS packages with cmd to a SQL Server, a file system or the package store using the dedicated dtutil command line tool.","og_url":"https:\/\/expert-only.com\/en\/ssis\/deploy-ssis-packages-with-cmd-and-dtutil\/","og_site_name":"SQL and IT Tutorials","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2022-11-02T06:23:00+00:00","article_modified_time":"2023-01-31T11:22:14+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/city-lights-8AD7D1A8877_1920x1080.jpeg","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":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/en\/ssis\/deploy-ssis-packages-with-cmd-and-dtutil\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/ssis\/deploy-ssis-packages-with-cmd-and-dtutil\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Deploy SSIS packages with cmd and the dtutil tool","datePublished":"2022-11-02T06:23:00+00:00","dateModified":"2023-01-31T11:22:14+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/en\/ssis\/deploy-ssis-packages-with-cmd-and-dtutil\/"},"wordCount":474,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/en\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/en\/ssis\/deploy-ssis-packages-with-cmd-and-dtutil\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/city-lights-8AD7D1A8877_1920x1080.jpeg","articleSection":["SSIS"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/en\/ssis\/deploy-ssis-packages-with-cmd-and-dtutil\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/en\/ssis\/deploy-ssis-packages-with-cmd-and-dtutil\/","url":"https:\/\/expert-only.com\/en\/ssis\/deploy-ssis-packages-with-cmd-and-dtutil\/","name":"Deploy SSIS packages with cmd - Dtutil utility - MS BI","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/en\/ssis\/deploy-ssis-packages-with-cmd-and-dtutil\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/en\/ssis\/deploy-ssis-packages-with-cmd-and-dtutil\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/city-lights-8AD7D1A8877_1920x1080.jpeg","datePublished":"2022-11-02T06:23:00+00:00","dateModified":"2023-01-31T11:22:14+00:00","description":"Deploy SSIS packages with cmd to a SQL Server, a file system or the package store using the dedicated dtutil command line tool.","breadcrumb":{"@id":"https:\/\/expert-only.com\/en\/ssis\/deploy-ssis-packages-with-cmd-and-dtutil\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/en\/ssis\/deploy-ssis-packages-with-cmd-and-dtutil\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/ssis\/deploy-ssis-packages-with-cmd-and-dtutil\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/city-lights-8AD7D1A8877_1920x1080.jpeg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/city-lights-8AD7D1A8877_1920x1080.jpeg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/en\/ssis\/deploy-ssis-packages-with-cmd-and-dtutil\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"en","item":"https:\/\/expert-only.com\/en\/"},{"@type":"ListItem","position":2,"name":"Deploy SSIS packages with cmd and the dtutil tool"}]},{"@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\/17531","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=17531"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/17531\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media\/6117"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media?parent=17531"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/categories?post=17531"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/tags?post=17531"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}