Executing SSIS package with SSAS task from c#

Question

I'm trying to run ssis package from c# application, console in current case; And in SSIS package i have simple Data flow tasks, and Analysis Service Task And its allway Faild with sych error

"To run a SSIS package outside of SQL Server Data Tools you must install Analysis Services Processing Task of Integration Services or higher. "

 try
        {
            var app = new Application();
            pkg = app.LoadPackage(location, null);
            pkg.EnableConfigurations = true;
            pkg.ExportConfigurationFile(@"E:\Olap\StatIntegration\Publisher.dtsConfig");
            foreach (var conn in pkg.Connections)
            {
                Console.WriteLine(conn.ConnectionString);
            }
            pkgResults = pkg.Execute();
            if (pkgResults == DTSExecResult.Failure)
            {

                foreach (var err in pkg.Errors)
                {
                    Console.WriteLine(err.Description);
                }
           }

Thanks alot!

GregGalloway GregGalloway · Accepted Answer · 2015-12-02T03:28:00

You need to use the SQL Server install media and install Integration Services. The error message is a bit buggy but that's what it means.

Executing SSIS package with SSAS task from c#

1 Answers