How do I read Top 10 records from Flat File Source in SSIS Package?

Question

I have Flat File with 17 rows with id, name header rows. How can we create SSIS Package to read first 10 rows from the Flat File Source using RowCount Transformation?

Answer 1

Hi @Ramana Kopparapu,

You can try to use Bulk Insert Task.

That task has LastRow setting so you can specify to read first 10 rows from the source file.

For the reference: https://www.tutorialgateway.org/bulk-insert-task-in-ssis/

Answer 2

Hi @Ramana Kopparapu,

You may use Script component as transformation to generate the sequence number for each of the record. Once we have the sequence number we will be using Conditional Split to get top X records or range of rows depending upon our requirement. 

Here is a tutorial you may take a reference to.

SSIS - Read Top X Rows From Flat File / Excel File OR Range OF Rows

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.