Hi all

I have created a very simple package.
It has a OLE DB Source, a Sort and a OLE DB Destination.
When I run it in the Integration Designer in Visual Studio, it works fine.

But when I like to execute the package in another C# Project, I get this error:
"To run a SSIS package outside of SQL Server Data Tools you must install Sort of Integration Services or higher."
When I remove the Sort Task, it works.

Here is my C# code:

*********************************************************************
MyEventListener eventListener = new MyEventListener();

Microsoft.SqlServer.Dts.Runtime.Package _Package;
Microsoft.SqlServer.Dts.Runtime.Application _Application;
Microsoft.SqlServer.Dts.Runtime.DTSExecResult _DTSExecResult;

_Application = new Microsoft.SqlServer.Dts.Runtime.Application();
_Package = _Application.LoadPackage(@"...\Package.dtsx", eventListener, true);
_DTSExecResult = _Package.Execute(null, null, eventListener, null, null);

System.Windows.Forms.MessageBox.Show(_DTSExecResult.ToString());
*********************************************************************

Thanks and best regards
Frank

Using SQL Server Configuration manager, can you check if SQL Server Integration Services is installed in your machine and if so is it in running state or not ?

In case it is not in running state then start the service and try your action again

It can be due to two reasons

1. Check if SSIS component (Integration Services service) is installed in your system. Go to Start_> Run type services.msc and see if Integration Services is listed

2. If its already there check if latest version of component is installed.

For example in our case we required to get SSIS 2012 to get it sorted in a server.

Hi all

I have created a very simple package.
It has a OLE DB Source, a Sort and a OLE DB Destination.
When I run it in the Integration Designer in Visual Studio, it works fine.

But when I like to execute the package in another C# Project, I get this error:
"To run a SSIS package outside of SQL Server Data Tools you must install Sort of Integration Services or higher."
When I remove the Sort Task, it works.

Looks like SSIS is not installed on your local.

So right now you can just run simple packages loading from source to destination etc... (Packages which can also be created from SQL Server import and export wizard)

If you try to use additional SSIS components/task such as Derived column, lookup, sort etc, won't work until SSIS is installed.

Please refer: http://blogs.msdn.com/b/michen/archive/2006/11/11/ssis-product-level-is-insufficient.as

Hi frank,

Based on the error message, it seems that SSIS is not installed or a lower SSIS version installed on the server on which the C# project was running.
 
To run the package outside SSDT, you need right version SSIS installed. The reason why the package runs fine with only Source and Destination components is that such a simple package can be executed by the DTExec utility installed by SQL Server 2012 Data base Engine or Client Tools (SQL Server Import and Export Wizard). To run a package that uses other tasks/components outside SSDT/BIDS, the SSIS runtime is also required except the DTExec utility. To obtain the SSIS runtime, we have to install SSIS on the server where the package runs.

Reference:
http://stackoverflow.com/questions/19989099/getting-error-running-ssis-package-on-non-ssis-server

Thanks,
Katherine Xiong

If you have any feedback on our support, please click here.