SSIS data flow task hangs when ran from SQL server agent job RRS feed

  • Question

  • Hi All,

    I am facing a strange issue from past few days.

    We are having a data flow task which dumps data to a excel from SQL server table. This excel file is dynamically generated at a sharepoint location.

    Also we are having a forloop to loop through different folders( around 50 folders) in sharepoint and create this file in each folder.

    This was running completely fine in production since last 1 year until last week.

    Suddenly that particular task started hanging after few hours of run ( may be after creating file in around 5-10 folders).

    It gets stuck in stage validation is beginning for that DFT task when i checked SSISDB logs.

    Surprisingly same dtsx gets completed when ran from visual studio.

    I changed the Delay Validation to True and Validate external metadata to false for this task and excel destination. But still same issue.

    Checked the server RAM and memory and that is fine while this is hanged.

    Could anyone please suggest what can be done here. This is our production environment and this issue has made production unstable.

    Please help.


    Wednesday, June 24, 2020 4:25 PM