SSIS error only happens when run via SQL Agent

  • When running in Dev environment (SSDT 2015) no errors happen. Data flow task creates XL files. Original report had 30 columns before error. Now as 30 more columns added to XL output it fails when run scheduled via SQL Agent with attached error. But runs fine in Data Tools. Excel 2010.  Any ideas on how to handle such issue?

    Attachments:
    You must be logged in to view attached files.

    Likes to play Chess

  • MSSQL 2014

    Likes to play Chess

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

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