Importing a .csv File into SQLExpress Using Bulk Insert
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.
The implementation details can be found in an article I published for the SQL Server World Wide User Group
The implementation details can be found in an article I published for the SQL Server World Wide User Group
Comments