Importing a .csv File into SQLExpress Using Bulk Insert
This entry was posted on 9/16/2007 2:33 AM and is filed under SQL Server.
With the introduction of Visual
Studio 2005, SQL Express can be installed on a developer’s workstation to allow
local database development. The client tools to access the local database
environment must be installed separately. We use SQL Server Management Studio
Express (SSMSE) in my customer environment. While SSMSE is easy to use, it does
not include features such as Integration Services. Certain tasks, such as
importing a .csv file are not available directly from the SSMSE user interface
i.e. you don’t have access to the SQL Server equivalent of the DTS Import/Export
Wizard. One approach to importing flat file data into SQLExpress is based on the Bulk Insert T-SQL command.
