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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-02-02 : 08:20:25
|
| Sarah writes "I have always used DTS's to import text files in the past, and have been designing a database as the destination based on an existing process. However, now that I have been given a sample file to look at, it's like this:BGM,H338DTM,137,041021,101DTM,205,041025,101DTM,167,041015,101DTM,168,041021,101QTY,7RTE,250AOA,1750And there can be multiple enties like above, all in one fileAnd as it isn't all on one line, I can't see how I can use a DTS to import it???!!!Pls Help!" |
|
|
rishimainidba
Starting Member
30 Posts |
Posted - 2005-02-02 : 09:41:23
|
| Use the BCP Command Utility for this. For more help on BCP goto Books Online.RegardsRishi |
 |
|
|
|
|
|
|
|
Import an EDI File using SQL DTS