Moving the log text file into sql server database

• balaji_rcs

  SSChasing Mays

  Points: 650

  More actions

  December 24, 2007 at 12:23 am

  #181460

  Hi,

  I want to create a DTS package for moving the log file into sql server database. A log file is stored inthe shared folder. If i execute the DTS package today, it will check the file name with yesterday date like "ex07112007" and if the file found, then it will start process the log file from the fifth line and put the entries in to the table. Can you please help me out how to proceed to create a package for this logic.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737004

  More actions

  December 24, 2007 at 10:08 am

  #762566

  You will need some scripting to identify the file and change the package to import it. Check http://www.sqldts.com for some ideas.

  Also, please post in the appropriate forum.