CODEWITHSUNDEEP
c#sql-serversql-server-2008ssis
littlechris
littlechris

Reputation: 4184

How to run a 2008 SSIS package from a win froms app on a user machine?

i've written a small c# 4.0 winforms app to get some input from the user and then pass this as a parameter to a SSIS package and then run the package.

I use the following code and it works fine on my development machine when I'm accessing the package on the production server.

        Microsoft.SqlServer.Dts.Runtime.Application app = new Microsoft.SqlServer.Dts.Runtime.Application();
        Package createInvoice = app.LoadFromSqlServer("\\MyPackage", "MyProducitonServer",
            null, null, null);
        createInvoice.Variables["PeriodID"].Value = _selectedPeriodId;
        DTSExecResult result = createInvoice.Execute();

However when I deploy the app to a users machine using a standard setup msi the app throws an error infomring me that it can't find an Integration Service Class and that the IS Server is not installed don the machine.

Can I run a package from the suers machine or do I have to schedule a job on sql agent to run the package for me?

Thanks

Upvotes: 1

Views: 1541

Answers (1)

ta.speot.is
ta.speot.is

Reputation: 27214

The SSIS Runtime is not a standalone package - it is packaged with Standard, Developer or Enterprise. If the client machine does not have SQL Server installed you cannot run the package on the client machine.

See here for a discussion.

Upvotes: 1

Related Questions