SSIS Package run based on variable
-
As you can see in the picture attached I am trying to execute the second level of the package ie T1A, T1B,T1C and T1D based on the variable hour .... like i want to run this package at 11am, 2pm, 3pm and 7pm and based on that the package should run T1A or T1B or T1C or T1D ....
Can you please let me know if my setup is correct or not because the package does not run after second layer i.e the date flow task 3 of package does not run ... execute sql works fine and T1B works fine .... if i remove the connection between T1C AND DATAFLOW
then it works fine but when i have two or more connections it doesnot work ...
FYI .....I have attched the image named package.bmp with this post
Please help me find the issue ....
Regards
-
the connection to the third tier is AND, not OR, and thus both T1B and T1C are needing to run.
Change that to an OR and that should clean up that portion.
- Craig FarrellNever stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA -
thanks alot
Evil Kraig F for pointing out that ... it was silly of me to overlook that....
i have another issue related to this package ... i need to create an output file using this package ..... and that should contain a header, data and a trailor ......
so here is what i am doing ... i m using 3 file connections to write to the same file .... and i am getting the desired result but i am getting something like the file i have attached ... i dont want to see the delimiters in my header and trailors of the file ....
how to take care of that ....
-
Change the internals of the data targets to only have a single column instead of just the copy/paste of the body. When I'm forced to do that I usually have header/trailer as a single connection, write at the beginning to it in one column with the necessary data, do the body drop, and then write again to it at the tail with the final data in a single column.
On a side note... I hate those damned header/trailer inclusions.
- Craig FarrellNever stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply