A、Import the data into a staging table by using the OPENROWSET BULK statement. Execute a Transact-SQL stored procedure to cleanse the data and to insert the data into the database.

B、Import the data into a staging table by using the BULK INSERT statement. Execute a Transact-SQL stored procedure to cleanse the data and to insert the data into the database.

C、Create a SQL Server Integration Services （SSIS） package to import， standardize， and cleanse the data.

D、Create a CLR stored procedure to import the data into a staging table， to cleanse and standardize the data， and to insert the data into the database.