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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy