This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(208, 79%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERB%3C/text%3E%3C/svg%3E)
How to read Top 10 records in flat file via SSIS?
Hope that you may gie the steps.
Thank u in advance.
Hi @R.B.V,
Do you have further question on this, could we offer more support?
If this helps on your issue, you could mark it as answer so other user with similar problem could see this easier. :)
You can't with default setting in data flow/flat file reader.
Read all and delete afterwards the unwanted records.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
Hi @R.B.V,
Bulk Insert Task in SSIS' Control Flow supports such functionality via LastRow and FirstRow parameters.
Here is a tutorial for you: https://www.tutorialgateway.org/bulk-insert-task-in-ssis/
Hi @R.B.V,
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.