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

Precedence Constraints Expand / Collapse
Author
Message
Posted Wednesday, April 22, 2009 1:36 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, May 19, 2010 3:52 AM
Points: 35, Visits: 129
Hi All,
I have a question about Precedence Constraints in data flow task. My scenario is i have used multicast to connect multiple destination. In that destination i have inserted to some of the tables. Destination2 table having foreign key of destination1. The destination2 will start once the destination1 completes. I dont know how it was worked. Whether i need to put any precedence over there.

Thanks in advance
Pras
Post #702097
Posted Wednesday, April 22, 2009 8:00 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 7:04 PM
Points: 1,114, Visits: 2,192
aprasy (4/22/2009)
Hi All,
I have a question about Precedence Constraints in data flow task. My scenario is i have used multicast to connect multiple destination. In that destination i have inserted to some of the tables. Destination2 table having foreign key of destination1. The destination2 will start once the destination1 completes. I dont know how it was worked. Whether i need to put any precedence over there.

Thanks in advance
Pras


Split your loading process in two separate data flows and make the second data flow execute only after the first data flow is done. There is no precedence constraint in a data flow.


---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Post #702355
Posted Tuesday, April 28, 2009 12:12 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, May 19, 2010 3:52 AM
Points: 35, Visits: 129
Thanks for your reply. I dont know how to run the second data flow task while the first data flow task is done. Can u clear this? I am curious to know how to do that.

Thanks
Post #705524
Posted Tuesday, April 28, 2009 1:17 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 12:24 PM
Points: 4,828, Visits: 11,183
You will have two dataflows appearing on your Control Flow - simply join (a) to (b) and you can be sure that (b) will execute after (a).

Not sure that helps you - as you want all of the processing controlled within a single DF task, I think. I can't see an obvious way of controlling precedence immediately after a Multicast, but I'm betting CozyRoc has a solution.



Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

When you ask a question (and please do ask a question: "My T-SQL does not work" just doesn't cut it), please provide enough information for us to understand its context.
Post #705547
Posted Tuesday, April 28, 2009 5:46 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 7:04 PM
Points: 1,114, Visits: 2,192
aprasy (4/28/2009)
Thanks for your reply. I dont know how to run the second data flow task while the first data flow task is done. Can u clear this? I am curious to know how to do that.

Thanks


You just connect the data flow tasks with the standard connector.


---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Post #705697
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse