Not able to execute SSIS package from WCF service hosted in IIS RRS feed

  • Question

  • Dear team,

    I have very simple SSIS package(Source- Excel, Destination : SQLserver using SSPI).
    I am able to run execute the package and able insert records in DB via directly SSIS project or directly executing WCF application from WCF testclient (without hosting in IIS).

    But when I refer this package in WCF service and host it to IIS package , am not any getting error while executing service or package NOT able insert records to DB.

    Tried with windows, Anymous acess and Custom account for application pool in IIS.

    Kindly assist me.


    Wednesday, August 6, 2014 8:25 AM


All replies