Can't work out how to do this, can anyone give some tips?
I have a dataabse project in Visual Studio 2010. The project includes a CSV file. I intend to import this CSV file at deploy time in the post-deployment script via something like
BULK INSERT table FROM '$(DefaultLogPath)\Data.csv'
but I can't find out how to copy the file to the DefaultLogPath.
asked Jun 24, 2011 at 02:20 AM in Default
Take a look at the pre and post deployment tasks. You should be able to put in a command line copy statement, or even a powershell call, from there.
answered Jun 24, 2011 at 03:36 AM
Grant Fritchey ♦♦