Post reply

DTSConnection ApplicationException Message 5

  • October 22, 2009 at 4:36 am

    #136874

    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}

    HelpLinknullstring

    +InnerExceptionnullSystem.Exception

    Message"5"string

    Source"DTEParseMgd"string

    StackTrace" at MgdParser.CreatePackage(Boolean bNeutral, Boolean bRemote)\r at Microsoft.SqlServer.Dts.DtsClient.DtsConnection.Open()\r 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

  • October 22, 2009 at 7:53 am

    #1069430

    Hi,

    from your infos I would have a look at permissions first.

    Could it be that the application pool user from the default web site is different to your special web site? If yes, could it be that this user does not have access to the E:\ directory?

    Error 5 (of 0x8???4005 or similar error numbers) in the MS world is nearly always an indicator of rights problems, because it originates from the OS error 5 "access denied"...

    WM_JUSTMY2CENTS

    Günter from Frankfurt/Germany

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply