Check for table constraints using ssis packages

• rahulsahay123

  Old Hand

  Points: 398

  More actions

  August 12, 2013 at 12:55 am

  #276137

  I am having 2 tables. source table and target table ie

  create table tableA

  (

  id integer

  ,fname varchar(20)

  ,lname varchar(20)

  )

  And

  create table tableB

  (

  id integer

  ,fname varchar(20)

  ,lname varchar(20) not null

  )

  Sample data:

  TableA

  1,'a','aa'

  2,'b',null

  So using packages when I am inserting data from tableA to tableB then package will fail for null records of tableA (fname) as fname cannot be null in destination table.

  How to make sure that packages run fine and the bad data is stored in error_table. Meaning tableB will have only 1 record and 1 record should go to error_table and package should execute successfully.

  Thanks

• Maxime.Gagne

  SSC Eights!

  Points: 886

  More actions

  August 13, 2013 at 9:25 am

  #1640998

  Hello,

  There are a few possibilities, here would be the most obvious two:

  1) Use a Conditional Split before your Insert to evaluate your NULLs and send them to Error_table

  2) Use the Error Output of the Destination Component to forward the rows in errors to your Error_Table

• rahulsahay123

  Old Hand

  Points: 398

  More actions

  August 17, 2013 at 11:32 pm

  #1642468

  Thanks for the Reply:)