split a large dataset

Saraabdi955

Hi,

I have over 10 milion records in a dataset and I want to import records to a SQL Server Table.

But I want to import each 100000 records in Database.

Can you help me how can I split the records and imports them in database?
Thanks a lot,

Datasets

Input

Parse

Macros

Database Connection

Accepted answers

All comments

Qiu

@Saraabdi955

Maybe we use the Record limit function in Input Tool together with a batch macro.

Saraabdi955

No, this dataset is sumation of so many files and I want split iteratively each 10000 records for example, first records 1 to 10000 import to database, then records 100001 to 20000 import to the same table of database and to end ...

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703