Hello,

I would need information about the different ways to load data in a
SQL Server from a flat file. I am aware of:

Integration Services
Bulk Insert
BCP

I would like to know, for each one:

Rights required. Admin in DB? Admin in system?...
Complexity
Version of SQL Server required
....

Another doubt. Access has an assistant to load data from a csv or txt
file. Doesn't exist some similar facility to load data to Sql Server.
I know SQL Server Migration Assistant from Access. Doesn't exist
something similar to txt files?

Any commercial product?


Thanks a lot for your help!

Regards,
David

You need to have write permission to the database table in any of
these options.
I prefer bulk insert option as it is the easiest and fastest way.
But if you have any processes to be done to the data before inserting
them to the table , better use SSIS

You need to have write permission to the database table in any of
these options.
I prefer bulk insert option as it is the easiest and fastest way.
But if you have any processes to be done to the data before inserting
them to the table , better use SSIS

You need to have write permission to the database table in any of
these options.
I prefer bulk insert option as it is the easiest and fastest way.
But if you have any processes to be done to the data before inserting
them to the table , better use SSIS

You need to have write permission to the database table in any of
these options.
I prefer bulk insert option as it is the easiest and fastest way.
But if you have any processes to be done to the data before inserting
them to the table , better use SSIS

You need to have write permission to the database table in any of
these options.
I prefer bulk insert option as it is the easiest and fastest way.
But if you have any processes to be done to the data before inserting
them to the table , better use SSIS

You need to have write permission to the database table in any of
these options.
I prefer bulk insert option as it is the easiest and fastest way.
But if you have any processes to be done to the data before inserting
them to the table , better use SSIS

You need to have write permission to the database table in any of
these options.
I prefer bulk insert option as it is the easiest and fastest way.
But if you have any processes to be done to the data before inserting
them to the table , better use SSIS

You need to have write permission to the database table in any of
these options.
I prefer bulk insert option as it is the easiest and fastest way.
But if you have any processes to be done to the data before inserting
them to the table , better use SSIS