none
SSIS Designer freezing up when using the Debug utility !

    Question

  • I am executing a single package that references 180 other packages , after executing the first 90-100 packages , SSIS designer completely freezes and then i have to kill the session using Task Manager . Is this a limitation of SSIS or is it a system constraint ?

    If you have any suggestions or workarounds for de same plz do reply

    Thanks in Advance
    Shailesh
    Tuesday, January 23, 2007 5:29 AM

All replies

  •  Shailesh Chaudhary wrote:
    I am executing a single package that references 180 other packages , after executing the first 90-100 packages , SSIS designer completely freezes and then i have to kill the session using Task Manager . Is this a limitation of SSIS or is it a system constraint ?

    If you have any suggestions or workarounds for de same plz do reply

    Thanks in Advance
    Shailesh


    Quick question...  Are any of the child packages copies of each other?  At least initially?  Ensure that the package GUIDs are all unique across your packages.  (Control flow, right-click, select properties.  Under ID, select the "generate new ID" option.)
    Tuesday, January 23, 2007 5:36 AM
  • Thanks for the quick response Phil .
    None of the child packages are copies of each other ....
    Though i will make sure that the GUID's are Unique


    Thanks again
    Shailesh
    Tuesday, January 23, 2007 7:20 AM