Link to home
Start Free TrialLog in
Avatar of tricks801
tricks801

asked on

Bulk Inserts

Currently I read in a file and then take each line from the file and run an INSERT statement. A bulk insert would be much faster however getting all the SQL servers to give the appropriate permissions would be too difficult right now.

Is there any other way to speed up the INSERTS?

Thanks
ASKER CERTIFIED SOLUTION
Avatar of Aneesh
Aneesh
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial