CODEWITHSUNDEEP
c#asp.netsqlssis
Shipu
Shipu

Reputation: 563

executing ssis package from a computer where integration services in not installed

I am using following line of code in a web application to execute a package which resides on other server where integration service is installed.But I am unable to execute it on application server.

        string pkgLocation;
        Microsoft.SqlServer.Dts.Runtime.Package pkg;
        Application app;
        DTSExecResult pkgResults;

        pkgLocation = @"\\hddlntd6021985\ssis\Package1.dtsx";

        app = new Application();
        pkg = app.LoadPackage(pkgLocation, null);
        pkgResults = pkg.Execute();

       Response.Write(pkgResults.ToString());

Upvotes: 1

Views: 6156

Answers (2)

luviktor
luviktor

Reputation: 2270

It is always a problem to run packages remotely. You've got several opportunities but neither of them may work perfectly. This article explains your opportunities and pros and cons of each. What you've tried to do is in the first point.

Another way can be use of PowerShell Remoting explained in this article. In one of my projects I runned remotely a package this way, but at the and the IT did not allowed to use it because of their security policy. (PowerShell Remoting opens ports 5985 and 5986) I think it is a simple solution. More simple than developing a service on the database server. So if you are allowed to open these ports on database server, you may consider using PowerShell.

Upvotes: 1

Pondlife
Pondlife

Reputation: 16260

You cannot run SSIS packages without installing SSIS. However, you can execute a package remotely (note the first sentence on that page) so your application server can still execute a package on the SSIS server.

Upvotes: 1

Related Questions