Does SQL Azure Support Bulk Insert from a File?

• smallmoney

  SSCarpal Tunnel

  Points: 4378

  More actions

  October 20, 2011 at 10:33 am

  #249798

  I'm just curious if this would work.

  If I connect to SQL Azure using SSMS on my local machine and the C:\something\something.csv is on my local machine.

  DECLARE @sql VARCHAR(255)

  DECLARE @path VARCHAR(255)

  DECLARE @filename VARCHAR(255)

  SET @path = 'C:\something\'

  SET @filename = 'something.csv'

  SET @sql = 'BULK INSERT dbo.Plans FROM ''' + @path + @filename + ''' '

  + ' WITH (

  FIELDTERMINATOR = '','',

  ROWTERMINATOR = '''',

  FIRSTROW = 2

  ) '

  PRINT @sql

  --EXEC (sql)

• Lowell

  SSC Guru

  Points: 323522

  More actions

  October 20, 2011 at 10:40 am

  #1397536

  you can use the .NET Frameworks SQLBulkCopy object , and use that to load via bulk copy, but not BULK INSERT command; that requires you to have already organized the data into a DataTable on the client side.

  if BULK INSERT were to be possible, the path to the file would be something like \\Your.Inernet.IP\c$\Somefolder\Somefile.csv, so that's not going to work.

  Lowell

  ---

  --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!