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 - 2003-04-18 : 09:18:52
|
| Chaari writes "I need to import some data in text and ASCII format into SQL Database. This has to be automized. Also, I need to export some data to some other systems. again in both ASCII and text format.Require experts opinion on how to design and implement the process. I have excellent background in SQL programming. I knew creating and executing simple packages.Appreciated any help in this regard." |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-04-18 : 10:38:23
|
| What do you mean by text and ascii format?Easiest method is to use bcp in a stored procedure for both import and export to/from staging tables minipulating the data before the export or after the import.If you have used sql server a lot as you say you should find this very quick to implement.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Import/Export ASCII and Text files