Data Type checks in SSIS Package

  • 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

    IdNameAge

    IntVarchar(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

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

    John

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply