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.
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 occursit 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 membersKindly help me get rid of this exception.Regards,Rashida Rauf |
|
|
|
|