question

Sima avatar image
Sima asked

I have a table of million records. I want to get 10 records at a time and load into new table. Next time when i run the "FOR Loop Task" in SSIS, It needs to Loop another 10 records.Please Suggest

Loop 10 records through SSIS

ssist-sqlsql-serverlooplooping
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image ThomasRushton ♦♦ ·

Why? What are you trying to achieve here?

-1 Like -1 ·

1 Answer

·
Sima avatar image
Sima answered

I have to load data of a table from one database server to another database server. I need to do it in batches so it will be faster. I am trying to with SSIS but i don't know how to do it

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.