automatically replace data in table -- sql server new users

HX
5/17/2007 7:19:56 PM

How can I automate the process of importing a new text file into an SQL 2000
table nightly?

The data will be posted on one server, and the SQL database is on another.
I can't even fathom the first step. Is there a tutorial or reference
someone can point me to?

Tom Moreau
5/18/2007 7:03:10 AM

Sounds like you need to create a DTS package with a text source and a SQL
Server target. Check out www.sqldts.com for useful tips.
--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau

[quoted text, click to view]
How can I automate the process of importing a new text file into an SQL 2000
table nightly?

The data will be posted on one server, and the SQL database is on another.
I can't even fathom the first step. Is there a tutorial or reference
someone can point me to?

sql server new users : automatically replace data in table