Need to import multiple files in a Directory with a Date Suffix

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  July 23, 2015 at 8:59 am

  #310086

  I need to import multiple Excel files into SQL Server on an ongoing basis. I need a timer to check for the existence of a file every 15 minutes for a specified number of hours.

  The naming convention is Import with a date suffix of 20150723. The file name would be Import20150723.xlsx.

  C:\Temp\Source to C:\Temp\Import

  I need to move and rename the file to C:\Temp\Source to C:\Temp\Import and Load it into a Table.

  I wrote a DTS Package and SSIS to automate finding the latest backup file in a folder and restore to a Development Server but that was years ago.

  Does anyone have a package that does something similar to this?

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/