Import text file from another server

• Kermit-297195

  Valued Member

  Points: 73

  More actions

  January 27, 2006 at 1:22 pm

  #167282

  Hi All,

  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:00 pm

  #617584

  Yes Possible using DTS.

  For a good resource on DTS Stuff.

  Go to DTS.com and there's a few tutorials you can look at.

  http://www.sqldts.com/?1