2 tasks cannot access the same object
Hello everyone, I am running into a rather strange issue with my SSIS package and was hoping someone could help. I will do my best to explain my issue... In my SSIS package I have an execute SQL task at the start that checks a value in a table. Based on that value, my SSIS package will either execute the remainder of the package OR wait 1 hour and then process the remainder of the package. I created a one hour delay in a loop container and have a precedence constraint on both that points to the next step in the process. The issue that I am having is that the loop container and the Execute SQL task are both pointing to the same object that completes the package. When I separate them out, the package runs fine, but when I run the package with both the execute SQL task and the Loop container pointing to the next step, it just runs the first step and stops. Can 2 tasks in SSIS point to the same object? Thanks, Dave Dave SQL Developer
July 23rd, 2012 10:24am

Precedence constrain was set to AND and not OR. Thank you all anyway. I wish they were all this easy :-DDave SQL Developer
Free Windows Admin Tool Kit Click here and download it now
July 23rd, 2012 11:38am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics