csv bulk insert with variables

• amdavis

  SSC-Addicted

  Points: 445

  More actions

  March 23, 2010 at 7:27 am

  #213089

  Use database1

  declare @date varchar(100) = (select Convert(VarChar, GetDate(), 112))

  Declare @fullpath varchar(100) = 'c:\templogs\'+(@date)+'-server1.csv'

  bulk INSERT server1 FROM '+@fullpath+'

  WITH

  (

  FIELDTERMINATOR = ',',

  ROWTERMINATOR = ''

  )

  How do I say from 'c:\templogs\20100323-server1.csv' using the declared @fullpath?

  The file name changes everyday because of the date change and I'd like to automate it.

  Help!

• Paul White

  SSC Guru

  Points: 150467

  More actions

  March 23, 2010 at 7:32 am

  #1138208

  Use dynamic SQL. See:

  sp_executesql and

  Using sp_executesql

  Paul White
  SQLPerformance.com
  SQLkiwi blog
  @SQL_Kiwi

• Ben Teraberry

  SSChampion

  Points: 11845

  More actions

  March 23, 2010 at 10:18 am

  #1138367

  If this is an everyday (or at least very regular) process, I would highly suggest taking the opportunity to learn and use SSIS.

  └> bt
  

  ---

  
  Forum Etiquette: How to post data/code on a forum to get the best help[/url]