Not sure if this is possible..

• krypto69

  SSChampion

  Points: 13604

  More actions

  November 16, 2011 at 7:35 am

  #247819

  I have a file that gets imported every morning.

  This file is named every day with the date. For example - '20111115_filename.xls'

  Long story short..I need to read to look at that file name and take the date from it and update the date field in my table with the correct date - 11/15/2011.

  Is this possible? Do I need to use SSIS?

• Lou

  SSCrazy

  Points: 2929

  More actions

  November 17, 2011 at 6:52 am

  #1409161

  Hi,

  Yes, sure you can do it,

  Please make a visit to or keep an eye into:

  http://bi-polar23.blogspot.com/2007/08/loading-multiple-excel-files-with-ssis.html

  You could register the file name in a table,a later you can play with it using string functions.

  Good Luck

• fitsumkh

  SSChasing Mays

  Points: 652

  More actions

  November 18, 2011 at 1:00 pm

  #1410164

  Here is a good article on how to set this up.

  http://www.mssqltips.com/tip.asp?tip=1443

  You can load the file name into a variable of the package and the rest is easy on what you want to do with it.