SSIS Flat File as Source and SQL Server As destination

• Phil Parkin

  SSC Guru

  Points: 247158

  More actions

  July 4, 2012 at 5:42 am

  #1508729

  tush002sunny (7/4/2012)

  ---

  I have the records in my flat file as below :

  HDR123495968908

  1111023456712345

  1234567890098007

  TRL4567897593494

  After the use of derived column I am able to map certain characters to the particular column of database table.

  Now while mapping to the database table I want to skip these header & trailer row.

  Data present in the SQL server table like this:

  column1 column2

  1111023 456712345

  1234567 890098007

  HDR1234 495968908

  TRL4567 897593494

  Will you Plz help me out for this doing in SSIS Package Transformation.........?

  Thanks...............!!!!

  One way is to use a conditional split. Check character one of the input data, and if it is H or T, redirect the row to a different output (which you do not need to use). That will effectively discard these rows.

  ---