Home Forums SQL Server 2005 Business Intelligence SSIS package not completing when running from SQL Server Agent job RE: SSIS package not completing when running from SQL Server Agent job

  • If you are using your executable from a UNC path you will have to add it in the zone setting in Local intranet.

    On your Internet Explorer, go to Security and select Local Intranet setting. Click on Sites and add your UNC path and click ok. The file:// protocol is added automatically.

    This has nothing to do with SSIS, but everything to do with the zone settings in Internet Explorer.

    This should help.