Post reply

2 ForEach Loop Containers using the same ADO RecordSet. One turns red in debugger

  • January 14, 2011 at 10:12 am

    #245356

    I have a pkg with 2 ForEach Loop Containers using the same ADO RecordSet. One turns red in the debugger but when I look in the progress tab to find the error explanation there is none and the output window states that the dtsx file finished successfully. How can I find out whats going on?

  • January 14, 2011 at 12:28 pm

    #1273738

    I searched and searced the web and finally found the answer. There is only one enumerator for the recordset so if you need to use it with more than one task you have to regenerate it.

    Found the info here

    http://qa.sqlservercentral.com/Forums/Post.aspx?SessionID=bcmhan55l33zsz55kt5uh145

  • January 14, 2011 at 12:34 pm

    #1273742

    dndaughtery (1/14/2011)

    I have a pkg with 2 ForEach Loop Containers using the same ADO RecordSet. One turns red in the debugger but when I look in the progress tab to find the error explanation there is none and the output window states that the dtsx file finished successfully. How can I find out whats going on?

    You cannot use the same ADO recordset in two separate 'For Each Loop' containers. You have to create separate recordset for each container.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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

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