Summary

Synopsis

The article discusses about how to perform a bulk insert into the database table using the Sql Scripts view.

Discussion

Say the data file which will be used to perform the bulk insert is going to be installed to the Installation directory of the setup. In that case, follow the steps below:

For InstallScript MSI and Basic MSI projects:

1. In the 'Sql Scripts' view on the 'Installation Designer' tab, create a Sql Connection and a Sql Script.
2. On the Scripts tab for the 'Sql Script', enter the script in following manner ?

BULK INSERT TABLE_NAME

FROM 'InstallationPathFILENAME'

WITH

(

FIELDTERMINATOR = ',',

ROWTERMINATOR = '\n'

)

3. In the above query, the TABLE_NAME will be the table, in which you want to perform the bulk insert; FILENAME will be the data file like data.csv, which you are installing with the setup.

4. On the ?Text Replacement? Tab, replace InstallationPath with [INSTALLDIR], since the data file will be installed in the Installation directory.

For InstallScript projects:

1. Steps 1-3 above will remain the same.

2. On the ?Text Replacement? Tab, replace InstallationPath with TARGETDIR since the data file will be installed in the Installation directory.

Additional Information