title: TRUNCATE TABLE query unable to execute in SSIS because of foreign key
body: <p>I have a table Person which contains 2 fields.In my another database i have a Participant Table(also have 2 columns).From Participant Table i have to insert values into Person Table.
  but before every insertion,i want truncate the person Table.</p>
  
  <p>I have try it out with linking Execute Sql task to Data flow task.But it is showing error that a Primary Foreign key relation exists there.</p>