Data Type checks in SSIS Package

• vipin_jha123

  Hall of Fame

  Points: 3085

  More actions

  October 13, 2015 at 3:59 am

  #399174

  Hi ,

  I have to perform several data cheks before loading data into target table.

  Foe example I am having 1 flat file with belo column

  Id Name Age

  Int Varchar(100) Int

  My requirement is to create package, checks will be performed on each record, column of the files.

  Any records which failed the checks considered as error records and will be written to the exception table.

  Can any one help me to achieve the above scenario.is there any example on web , as I am searching the solution of above scenario.

  Thanks in Advance

• John Mitchell-245523

  SSC Guru

  Points: 148786

  More actions

  October 13, 2015 at 4:04 am

  #1832942

  Bring everything from the flat file into a staging table and do the checks there.

  John