syntax needed

• Shanmuga Raj

  Ten Centuries

  Points: 1178

  More actions

  May 6, 2013 at 7:29 am

  #273557

  The uncommented part is not working

  declare @str_folder_path varchar(1000)='\\Dataupload'

  ,@str_media_data_file_path_csv varchar(200)='Data File.csv'

  BULK INSERT vw_pkg_dataload

  --FROM '\\Dataupload\Data File.csv'

  FROM '''' + @str_folder_path + '\' + @str_media_data_file_path_csv +''''

  WITH

  (

  FIRSTROW = 2,

  FIELDTERMINATOR ='|',ROWTERMINATOR = ''

  )

• Lowell

  SSC Guru

  Points: 323507

  More actions

  May 6, 2013 at 8:22 am

  #1612647

  the FROM property for bulk insert must be a static string...it cannot be created from appended variables.

  BULK INSERT BULKACT FROM 'c:\Export_o.txt'

  to do what you want, you need everything to be dynamic SQL.

  --cursor loop?

  --bulk insert won't take a variable name, so make a sql and execute it instead:

  set @sql = 'BULK INSERT BULKACT FROM ''' + @path + @filename + ''' '

  + ' WITH (

  DATAFILETYPE = ''char'',

  FIELDTERMINATOR = '','',

  ROWTERMINATOR = ''\n'',

  FIRSTROW = 2

  ) '

  print @sql

  exec (@sql)

  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!

• Steve Jones - SSC Editor

  SSC Guru

  Points: 734587

  More actions

  May 6, 2013 at 8:45 am

  #1612651

  BOL doc: http://msdn.microsoft.com/en-us/library/ms188365.aspx