InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 13:25:23 GMT20http://www.sqlservercentral.com/Forums/Topic1193887-2571-1.aspxyou 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.Thu, 20 Oct 2011 10:40:42 GMTLowellhttp://www.sqlservercentral.com/Forums/Topic1193887-2571-1.aspxI'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.[code="sql"]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)[/code]Thu, 20 Oct 2011 10:33:27 GMTsmallmoney