Run the SSIS Package using sql server Agent--Memory utilization Problem RRS feed

  • Question

  • Hi,

    I have Created one SSIS Package it was working fine in BIDS but in SQL Server Agent it takes all the server memory and server gets very slow now.

    in that ssis package i am using merge join,sorting tasks.Can you please suggest me how to handle in the memory usage for this..pls refer the below screen

    Friday, March 21, 2014 8:26 AM


All replies