What is the fastest method to load data in sql

Help Something Else
1

I used bulk insert to update the data from excel to sql and it is taking some time so is there any better way to do this?

2

@sathish_Kumar6

Bulk insert is ideally the fastest way depending on the size of data it might take little time

cheers

1 Like
3

Okay thanks but can we do by invoking any code and make it faster is that possible?

4

@sathish_Kumar6

Try runnign from orchestrator you would see it faster…generally in debug it is little slow

cheers