SQL Server – Engine – Data Export and Import- Error – “The Execute Package utility requires Integration Services to be installed”


There is one little hurdle that one might have to cross when one uses “Microsoft SQL Server Management Studio – SQL Server Import and Export Wizard” to import and export data.


The hurdle occurs when one tries to later re-use the package created. If “SQL Server Integration Services” is not installed on the machine, one gets the error pasted below:

Error: The Execute Package utility requires Integration Services to be installed by one of these editions of SQL Server Standard 2008: Standard, Enterprise, Developer, or Evaluation.  To install Integration Services, run SQL Server Setup and select Integration Services.



















The error is straightforward.


There are a couple of solutions, inclusive:

  1. Install the latest evaluation version SQL Server and be sure to include “Integration Services“.
  2. Convert the package

Install Evaluation Copy of SQL Server

Download MS SQL Server 2012 – SP1 Trial Edition

Download MS SQL Server 2012 – SP1 Trial Edition

Download Microsoft SQL Server 2012 – SP1 from here.

Install MS SQL Server 2012

Install the downloaded version and make sure that you include Integration Services as part of installation.

Backup package

Make a copy of the package.  Using MS Windows Explored, please make a copy of the package.

Use Project Conversion Wizard

Use “SQL Server 2012 \ Integration Services \ Project Conversion Wizard”


     This step did not work for our purpose as it does not produce

          the traditional dtxs/XML file, but a binary file (.ispac); which needs to

          be deployed to SQL Server/msdb or SSIS ENgine


Hopefully, you installed the tooling components that come with SQL Server 2012.  The nice tool known as Integration Services \ Project Conversion Wizard comes with it.

Launch Tool

Launch that tool and choose to convert the package

Locate Packages

The Locate Package window allows to choose the package’s location.  Remember a package can be saved on the File System \ SSIS Package Store \ SQL Server (msdb).


Select Packages

Select the packages that you want converted.


Select Destination

Select the packages destination

Please create and select a new folder to save the new files.

Here you will have to deal with the more contentious aspects of SSIS /DTS packages; what to do with the step child that are packaged as “sensitive data“.

As always, I will skip the hard part by choosing “DontSaveSensitive”.

Select Destination


Configuration and Parameters

Based on your packages, you might have to deal with configurations and parameters.


Review your choices:



Review your choices.



Please review the result of the conversion process.



And, click on the close button.

Execute Package

Launch SQL Server Integration Services Execute Package

Launch “Microsoft SQL Server 2012” / “Integration Services” / “Execute Package Utility”


General – General – Load File

General File System


File System

Empty File System as dtsx file not found!

ChooseFileSystemFile - dtsx

Using IDE ( Business Intelligence Studio [BIDS] / SQL Server Data Tools [SSDT]) Convert Package to new Version

Using SQL Server Business Intelligence BIDS  or SQL Server Data Tools convert package to new version.

We will use SQL Server Data Tools BI.


Download SSDT (Microsoft SQL Server Data Tools – Business Intelligence for Visual Studio 2012) from http://www.microsoft.com/en-us/download/details.aspx?id=36843.

Install SSDT

Install SSDT

Launch SSDT

Launch “SQL Server Data Tools for Visual Studio 2012” (SSDT)


Open File

Using menu items (File \ Open file) …

The package is automatically updated:

The package is upgraded.
See the list of warning and information messages for details.


Save the “File As”

Use the menu “File / Save As” to save the file under a new name:


Again, chose not to “Save sensitive”:


Use “SQL Server Execute Package” to execute the package

Initiate SQL Server Execute Package

Using the Start button, initiate “Microsoft SQL Server 2012” \ “Integration Services” \ “Execute Package Utility”


Initiate SQL Server Execute Package

Using the Start button, initiate “Microsoft SQL Server 2012” \ “Integration Services” \ “Execute Package Utility”

Execute Package Utility – General

The first window that occurs is the “General” window:


Choose :

  • Package source :- File System
  • Package :- choose the file


Execute Package Utility – “Connection Managers”

Make sure that you edit the DB Connection Settings:


Once you have made necessary changes, please click the Execute button.


In summary, you need SQL Server Integration Services to execute saved SSIS packages.

SQL Server Integration Services Conversion Wizard is promising, but a bit restrictive when one wants to quickly make and re-execute changes.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s