Deployed SSIS package not writing to text file RRS feed

  • Question

  • Hello.

    I have a SSIS package that checks for records in a table and then sends information in an email to a person as well as log the information to a text file. This all works great in my BIDS program. I deployed it to the SQL server and set it up to run on a job it runs ok but it is not writing to the text file. If I log onto the server for Integration Services I am able to excute the package there and .it will write the information to the text file but when I set it up a job to run from the SQL Server Agent it runs fine but it is not writing to the text file. Any ideas? tks!

    Reach for the unknown!

    Monday, February 16, 2015 7:32 PM