Use the Import Export Wizard, found in the SQL Server group on the start
menu.

Importing A Text File Using The DTS Wizard
(http://www.sqldts.com/default.aspx?276)


--
Darren Green
http://www.sqldts.com

"jeff" <jeff (AT) emscirc (DOT) com> wrote

Do you have a file per destination entity?

If you are new to DTS then you can read these.

DTS Tutorials
(http://www.sqldts.com/default.aspx?107)

You may also like to read up on BULK INSERT in Books Online.

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"jeff" <jeff (AT) emscirc (DOT) com> wrote