You need to cleanse and standardize the data on potential survey participants prior to inserting it into the staging database. What should you do?（）

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.
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.