Upload to Sql Error

1

Hi,

We trying to do a bulk upload to Sql database in Azure…below our code + the error. Any hints?

BULK INSERT stepx_health
FROM ‘C:\Users\User\WherWe Dropbox\Robert Lipschitz\ABINBEV\BudClub\MonthlyProjects\Project Tools\Modules\tempSQLdump.csv’
WITH ( FORMAT=‘CSV’);

Error: Cannot bulk load because the file “C:\Users\User\WherWe Dropbox\Robert Lipschitz\ABINBEV\BudClub\MonthlyProjects\Project Tools\Modules\tempSQLdump.csv” could not be opened. Operating system error code (null).

2

Hi Robert,

SQL server should have access to the specified CSV file in order BULK INSERT to work.

Which seems to be impossible with Azure SQL DB.

Try to use bcp utility instead.