July 23, 2012 at 8:33 am
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
July 23, 2012 at 9:33 am
Precedence constrain was set to AND and not OR.
Thank you all anyway. I wish they were all this easy 😀
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply