How to set limit in SSIS

Hi,

I am trying to import some 35-40 flat files into my SQL Database, however I don't want to imort all the data from each file, but just top 20 rows only for data quality check. Flat files are very huge so I don't want to import all of the data into my database.

Thanks,

gpat

gvphubli wrote:

Hi,

I am trying to import some 35-40 flat files into my SQL Database, however I don't want to imort all the data from each file, but just top 20 rows only for data quality check. Flat files are very huge so I don't want to import all of the data into my database.

Thanks,

gpat

Does this help?

Select Top N in a data-flow

(http://blogs.conchango.com/jamiethomson/archive/2005/07/27/SSIS-Nugget_3A00_-Select-Top-N-in-a-data_2D00_flow.aspx)

-Jamie