SSIS: How to limit the number of rows copied from flat file

• mrp2

  SSC Veteran

  Points: 231

  More actions

  March 11, 2008 at 7:34 am

  #120697

  Is there a way to limit the number of rows copied from a flat file into sql server using an SSIS package. I have a flat file with about 10 million records. I only want to copy over the first million. I'm new at this, thanks for your help.

• Jay1234

  SSCommitted

  Points: 1624

  More actions

  March 11, 2008 at 10:25 am

  #788120

  Use Row Sampling task in data flow transformation and specify number of records you wanted.