Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 DTSConnection ApplicationException Message 5

Author  Topic 

iamrashida83
Starting Member

1 Post

Posted - 2009-10-22 : 06:32:11
Hi,

I am trying to execute ssis package from my asp.net application using file DTSConnection when i execute web application normally it works fine but when i execute same web application using virtual directory it throws application exception when opening DTSConnection and exception only contain message {"5"} nothing else my code is:

string packagePath = "E:\\Package.dtsx";
DtsConnection conSSIS = new DtsConnection();
conSSIS.ConnectionString = String.Format("-f \"{0}\"", packagePath);
conSSIS.Open(); --> here exception occurs

it works fine when running like:
http://localhost:4015/PackageWeb/

but throws error while running like:
http://localhost/PackageWeb/

Exception Details:
ex {"5"}
+[System.ApplicationException] {"5"} System.ApplicationException
+Data {System.Collections.ListDictionaryInternal} System.Collections.IDictionary {System.Collections.ListDictionaryInternal}
HelpLink null string
+InnerException null System.Exception
Message "5" string
Source "DTEParseMgd" string
StackTrace " at MgdParser.CreatePackage(Boolean bNeutral, Boolean bRemote)\r\n at Microsoft.SqlServer.Dts.DtsClient.DtsConnection.Open()\r\n at Pral.ERP.ePayments.DBEPaymentsMain.RetrieveDataFromSSISPackage(String packageName, String readerName, String parameterName, String parameterValue) in e:\\Projects\\VS 2008 Projects\\eFBR_BankBridge\\App_Code\\ePayments\\Data\\DBEPaymentsMain.cs:line 1295" string
+TargetSite {System.Object CreatePackage(Boolean, Boolean)} System.Reflection.MethodBase {System.Reflection.RuntimeMethodInfo}
+Static members
+Non-Public members


Kindly help me get rid of this exception.

Regards,
Rashida Rauf




   

- Advertisement -