Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 MSSQL

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-01-28 : 09:20:43
Rina writes "How can i import a fields from notepad to mssql.I'll have to read from 2 separate notepad files into one mssql database so that another help desk application can extract these fields form MSSQL.Do I use Data Transformation Services.Please advise how to do this."

royv
Constraint Violating Yak Guru

455 Posts

Posted - 2003-01-28 : 09:48:50
DTS is one option, you could also use BCP. This site has articles on both if you need to know how they work, also Books Online talks about it them as well.

***************************************
Death must absolutely come to enemies of the code!
Go to Top of Page
   

- Advertisement -