ETL and Data Integration tools - Modern ETL software for everyone

I've got an import set up where it's taking a table from a local Access DB and using that as the source and I'm going to import it into our live MSSQL server. The table is like 80K records. I'm a little hesitant to do it all in one shot. Is it possible to tell VIMP to do like 5000 records, stop, then do the next 5000 records, and so on until it's done?

Because if there's an internet failure or something after 23,000 records, I'd like to just restart at batch #4 for example than to try it all over again.

I see that I can set the batch size, but I don't see a way to say start on batch #6 for example.

Thanks!

Tood.

80k is not a lot of records
2 Millions are.

I think you should be ok

Mike

I know it's not a lot of records but
1) our internet connection at the office sucks (think a cross between carrier pigeons and smoke signals) and
2) I'm paranoid!

Well, I'll let 'er rip...

Thanks!

I bit the bullet and just let it all go and it worked just fine. Thanks again for your help!