Mar 25, 2013 11:46 AM
Where to put data files for BULK INSERT in Basic MSI project
I need to populate a very large SQL table (268,000+ rows & 200+ columns) in a Basic MSI project, and I plan on using BULK INSERT for this. That's no problem, but the only thing I'm not sure of is where to put the flat file in the project. I don't have a lot of MSI experience, so I'm not sure if putting this file in a component is the best way to go. The bottom line is that I don't want the flat file left on the user's system after the installation completes, and I don't want to have to deal with Windows Installer's annoying file protection. I just want to insert the data and get rid of the file.
Mar 25, 2013 12:12 PM
If you don't want the files installed, you'll have to put them in SUPPORTDIR. You'll also have to use search and replace commands in your SQL files to rewrite the bulk insert commands to reference the files in SUPPORTDIR.