tsql - Table should be created using year month and date in SSIS? -


i have folder .xlsx file every day. have ssis copy data .xlsx file table stackdata. need create ssis package such way when run package table should created year month , date stachdata_20130819.

declare @d char(10) = convert(char(8), getdate(), 112);  if object_id('report_temp.msk_traffic_backup_' + @d) null  begin      declare @sql nvarchar(max) = n'select * report_temp.msk_traffic_backup_' + @d + ' property.door_traffic;';      print @sql;      --exec sp_executesql @sql;  end  

Comments

Popular posts from this blog

Detect support for Shoutcast ICY MP3 without navigator.userAgent in Firefox? -

web - SVG not rendering properly in Firefox -

java - JavaFX 2 slider labelFormatter not being used -