Check data in Flat File before importing

• chh17_2000

  Grasshopper

  Points: 14

  More actions

  May 12, 2009 at 10:44 pm

  #137728

  Hi,

  I have a package that has a Data Flow Task that Import data from a Flat File Source to the database.

  Is it possible to check the data or selective import data(based on certain criteria) from the flat file before importing to the database?

  For example, my flat file has three columns

  - GeneralId

  - Description

  - PostedDate

  I would like to import those records from the flat file that has a certain generalId and PostedDate into the database.

  Best regards,

  John

• Samuel Vella

  SSCrazy Eights

  Points: 8055

  More actions

  May 13, 2009 at 1:25 am

  #993481

  you can use a conditional split in the data flow transformation

  Anything meeting your criteria can go into the database, everything else can be ignored

• Phil Parkin

  SSC Guru

  Points: 247180

  More actions

  May 13, 2009 at 3:24 am

  #993513

  If you need more sophistication in your record selection than is possible in Conditional Split, the Script Component will also do it.

  ---