How do I retrieve only the top x rows from a flatfile in SSIS

Question

I have a flatfile connection and I'm only interested in the first 10 rows of data. How can I just import the first 10 rows? Row sampling is random so I can't use that. Is there some way I can have some sort of derived column which is an automatic row number or something and then data-split to only keep rows with that id <= 10?

Any help much appreciated!

Can you use a Script Component as a data flow source? If so this is simple to implement. — Faiz, Sep 27 '09 at 05:49

score 2 · Answer 1 · answered Sep 25 '09 at 12:56

I've used this component --> http://www.sqlis.com/post/Row-Number-Transformation.aspx

The component creates a new variable with a row number. You can use a conditional split to take the first 10 records based on the variable the component creates.

One catch is that you will need to read in the entire file. Depending on your file size you may want to seek another solution.

score 0 · Answer 2 · edited Oct 29 '12 at 11:59

0

There isn't a direct way of doing that. You can try a work around method by using the "Data rows to skip" property:

Screenshot of the connection manager editor

You can "invert" your file and skip all first rows -10

edited Oct 29 '12 at 11:59

Deanna

23,876
7
71
156

answered May 08 '12 at 11:01

Diego

34,802
21
91
134

score 0 · Answer 3 · answered Jun 19 '19 at 08:33

0

Just use a lineCount component with a user variable and a conditional Split based on the value of that variable/

answered Jun 19 '19 at 08:33

Farid Hatimi

1
1

How do I retrieve only the top x rows from a flatfile in SSIS

3 Answers3

Linked