pumping data from different files in samd location

• daomingsi

  Grasshopper

  Points: 21

  More actions

  April 11, 2005 at 6:05 pm

  #362391

  I'm trying to create a dts package that will pump data from excel file to sql server using the data transform task.  For the source file, I need to specify the path and the file name from the source connection. But this package needs to run several times a week.  

  For example:

  day 1 will pump test1.xls from C:\test1.xls

  day 2 will pump test2.xls from C:\test2.xls

  day 3 will pump test3.xls from C:\test3.xls

  I can't just change the filename in the source connection everytime in the package.  So, what can I do to get around with this.  Write activeX script? I really have no idea

  Please help. Thanks

• philcart

  SSC-Forever

  Points: 47797

  More actions

  April 11, 2005 at 7:08 pm

  #552005

  Take a look at the examples over at http://www.sqldts.com

   

  --------------------
  Colt 45 - the original point and click interface

• Shyamala Dhakshinamurthy

  SSC Journeyman

  Points: 96

  More actions

  April 12, 2005 at 7:49 am

  #552135

  Look into the article

  http://www.sqlservercentral.com/columnists/djackson/importingthelatestfileinafolderviadts.asp

  Hope this helps,

  Shyamala.