execute sql task with precedence constraint

Who is online?  0 guests and 0 members
Home  »  Forums   »  microsoft business intelligence   »  integration services   » execute sql task with precedence constraint

execute sql task with precedence constraint

Topic RSS Feed

Posts under the topic: execute sql task with precedence constraint

Posted: 4/30/2012

Jedi Youngling 8  points  Jedi Youngling
  • Joined on: 3/21/2012
  • Posts: 4

Hi everyone,

i have table with some columns,   using the data flow task i loading records into oracle table . i wanted to know  after migration for a  particular  column we have to check  particular   record is present or  not.  if the record is not their then in the next dataflow task it will fetch from other source and data is loaded . if record is present then next dataflow task should not run.

 

please  Suggest me for this   how make use precedence constraint .


Posted: 4/30/2012

Jedi Master 2837  points  Jedi Master
  • Joined on: 2/19/2010
  • Posts: 414

Is the record/value you are checking for a fixed thing or variable with every load?  To me it sounds more like you should just use a conditional split or a lookup in your first data flow to determine whether or not to run the subsequent load.


Posted: 4/30/2012

Jedi Youngling 8  points  Jedi Youngling
  • Joined on: 3/21/2012
  • Posts: 4

Posted: 5/2/2012

Jedi Youngling 8  points  Jedi Youngling
  • Joined on: 3/21/2012
  • Posts: 4
Page 1 of 1 (4 items)