I'm running an SSIS package from asp.net, and I get the error "The LoadFromSQLServer method has encountered OLE DB error code 0x80004005 (Login timeout expired)."I can run the package from BIDS and locally on the server. Those aren't a problem. It's just when I run it from .NET that it gets this error. As background, the web server is on the same machine with SSIS. I am using a local admin account to connect. Here's a small code sample:Microsoft.SqlServer.Dts.Runtime.Application app = new Microsoft.SqlServer.Dts.Runtime.Application();Microsoft.SqlServer.Dts.Runtime.Package pkg = app.LoadFromSqlServer( "\\" + packageName, LPS.Net.Utilities.GetKeyValue("SSIS"), ConfigurationManager.AppSettings["Username"].ToString(), ConfigurationManager.AppSettings["Password"].ToString(), null);/* LOAD CONFIG FILE */pkg.ImportConfigurationFile(Server.MapPath(".") + "\\ssis\\" + packageName + ".dtsConfig");Microsoft.SqlServer.Dts.Runtime.Variables vars = pkg.Variables;vars["ImportID"].Value = importID;vars["Filename"].Value = fileName;Microsoft.SqlServer.Dts.Runtime.DTSExecResult result = pkg.Execute();
Running SSIS from ASP.NET
Posted - 2009-01-06 : 13:56:45
