import logs into database

• Kermit-297195

  Valued Member

  Points: 73

  More actions

  January 27, 2006 at 1:46 pm

  #103062

  Hi All,

  I posted this in the wrong forum before....I am very new to SQL Server 2000.  I hope someone can help.  Hourly text file logs are generated on Server1 and I need to import them into an existing SQL Server 2000 table on another Server2.

  I need to somehow specify to only import the latest log generated.  Is this possible using DTS?  If not, what other options exist?

  Thank you.

• Ray M

  SSC-Insane

  Points: 21093

  More actions

  January 27, 2006 at 3:01 pm

  #617585

  Its Okay, usually everyone checks all boards

  I attached some infor in your original post

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=254203