Import/export multiple SSIS packages
While I was working on a migration project recently, I had the task of importing and then exporting multiple packages - about 120~ on to a new server. Usually, if there are less numbers of packages we can do this task manually but, in this case it was tedious and time consuming to import and then export it manually. Here's where the utility DTUTIL comes in handy, this utility has many options that you can use according to your need. What I used is very simple and easy to use. I created a two batch file using the below commands: Exporting SSIS Packages to File: dtutil /SQL ExportPackage /COPY FILE;C:\Packages\ExportPackage.dtsx Importing SSIS Package to SQL: dtutil /file C:\Packages\ImportPackage.dtsx /copy sql;ImportPackage Find out more details and a comprehensive list of options. Discover more about our expertise in SQL Server.
Share this
Previous story
← Creating a test lab using VirtualBox / NAT networking
You May Also Like
These Related Stories
How to migrate from Teradata to Google BigQuery
How to migrate from Teradata to Google BigQuery
Sep 30, 2019
2
min read
Why Comprehensive Health Checks for MS SQL Servers Matter: Part 1
Why Comprehensive Health Checks for MS SQL Servers Matter: Part 1
Nov 29, 2021
3
min read
How to configure X11 for Vagrant Box
How to configure X11 for Vagrant Box
Apr 10, 2019
6
min read
No Comments Yet
Let us know what you think