Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SSIS Package run based on variable


SSIS Package run based on variable

Author
Message
abhisheka.dalal
abhisheka.dalal
Grasshopper
Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)

Group: General Forum Members
Points: 14 Visits: 74


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
Attachments
package.bmp (6 views, 1.00 MB)
Evil Kraig F
Evil Kraig F
SSCertifiable
SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)

Group: General Forum Members
Points: 5715 Visits: 7660
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 Farrell

Never 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 | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables

Twitter: @AnyWayDBA
abhisheka.dalal
abhisheka.dalal
Grasshopper
Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)

Group: General Forum Members
Points: 14 Visits: 74
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 ....
Attachments
test.txt (4 views, 357 bytes)
Evil Kraig F
Evil Kraig F
SSCertifiable
SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)

Group: General Forum Members
Points: 5715 Visits: 7660
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 Farrell

Never 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 | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables

Twitter: @AnyWayDBA
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search