Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS Package run based on variable Expand / Collapse
Author
Message
Posted Friday, April 4, 2014 1:45 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, April 7, 2014 9:09 AM
Points: 5, Visits: 35


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


  Post Attachments 
package.bmp (5 views, 1.44 MB)
Post #1558637
Posted Friday, April 4, 2014 2:18 PM This worked for the OP Answer marked as solution


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:10 PM
Points: 6,139, Visits: 7,193
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
Post #1558647
Posted Friday, April 4, 2014 2:29 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, April 7, 2014 9:09 AM
Points: 5, Visits: 35
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 ....


  Post Attachments 
test.txt (2 views, 357 bytes)
Post #1558651
Posted Friday, April 4, 2014 2:50 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:10 PM
Points: 6,139, Visits: 7,193
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
Post #1558659
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse