June 25, 2018 at 5:20 am
Hi,
I have a table with 200 000 records, I need to send a file with 50 000 records. I'm using MS SQL 2016. I'm not sure how to go about it but I think my logic will be on my SSIS Package. help.
June 25, 2018 at 5:25 am
Duplicate of https://www.sqlservercentral.com/Forums/1970852/SSIS-How-to-load-a-data-from-a-table-to-a-file-into-50-000-batches-50-000-rows-at-a-time. Please direct answers to the other topic.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 25, 2018 at 5:26 am
sirkinghorse - Monday, June 25, 2018 5:20 AMHi,
I have a table with 200 000 records, I need to send a file with 50 000 records. I'm using MS SQL 2016. I'm not sure how to go about it but I think my logic will be on my SSIS Package. help.
Use a query as your data source:select top (50000) [column list]
from table
order by ...
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
June 25, 2018 at 5:27 am
Thom A - Monday, June 25, 2018 5:25 AMDuplicate of https://www.sqlservercentral.com/Forums/1970852/SSIS-How-to-load-a-data-from-a-table-to-a-file-into-50-000-batches-50-000-rows-at-a-time. Please direct answers to the other topic.
Oops ... my apologies, saw this too late.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
June 25, 2018 at 5:34 am
Phil Parkin - Monday, June 25, 2018 5:27 AMThom A - Monday, June 25, 2018 5:25 AMDuplicate of https://www.sqlservercentral.com/Forums/1970852/SSIS-How-to-load-a-data-from-a-table-to-a-file-into-50-000-batches-50-000-rows-at-a-time. Please direct answers to the other topic.Oops ... my apologies, saw this too late.
Ha, you were only a minute after me, you were probably already typing before I'd posted that. 🙂
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply