Hi,

It just take a few seconds...

If im doing it after running the cache then its takes just 2-3 seconds only..

Thanks,

Naveen

Hi,

Adding some more information....

Actually im planning to use an execute sql task so that i can call a stored procedure with that parameters....

The reason im not using the ole...

100 records was just an example...Actually by 1000 records i meant was to insert large number of records....

Explaining the working of the application is a below...

There is a application from...

Sorry friend..for that late reply..

just got deviated to some other stuffs..

Thanks anyways...

i tried out your recommended way and it worked..

Thanks,

Naveen

Thanks for the quick reply...

one issue that i have is that....my primary key column supplied in the excel file for each table is not real....the real ie will be generated...