Hi, I have created 1 SSIS pacakge and i am calling that ssis pacakge from ASP.Net website which is hosted in IIS but it give following error. "SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80040E4D Description: "Login failed for user "sa".". Failed to acquire connection "San Test". Connection may not be configured correctly or you may not have the right permissions on this connection. " and My Asp.Net Code is try { Application app = new Application(); Package package = null; package = app.LoadPackage(@"D:\PUBLIC\SSIS PROJECT\SSIS_Project\SSIS_Project\bin\Package.dtsx", null); Microsoft.SqlServer.Dts.Runtime.DTSExecResult results = package.Execute(); string Failed = string.Empty; if (results == Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Failure) { foreach (Microsoft.SqlServer.Dts.Runtime.DtsError local_DtsError in package.Errors) { Failed = Failed + local_DtsError.Description.ToString().Replace("'", "\""); } } } catch (DtsException ex) { //Exception = ex.Message; string err; err = ex.Message; } It give error at below mention line " if (results == Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Failure) " Well my package protection level is "EncryptSensitiveWithUserKey" Plz Help me out from this.

Since you have a password in your package (the sa password) you are going to need to change the package protection level to EncrypSensitiveWithPassword and pass the password in (http://msdn.microsoft.com/en-us/library/ms141747.aspx). To load the package you need to set the PackagePassword property of the app object http://agilebi.com/jwelch/tag/ssis-api/ , Add a line to your code: app.PackagePassword = "PackagePassword"; package = app.LoadPackage(@"D:\PUBLIC\SSIS PROJECT\SSIS_Project\SSIS_Project\bin\Package.dtsx", null); Russel Loski, MCT