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 |
|
paull
Yak Posting Veteran
50 Posts |
 Posted - 2009-05-06 : 11:42:57
|
| Hi guysI am moving all the data storage on a project to SQL (Express for now while I try to learn and prove the concept to the bean counters!) from flat ascii format that we have used for years. I can recreate all the reports and listings that I need using simple queries, however, it has come about that I need to supply a client the data in the "old" format to the same map. Therefore my question has 2 parts, firstly, how do I export to ascii without using SSIS? I have looked at DTS but it doesn't give any options for record length etc. And secondly, is there an easy/quick way to "set up" the old map? There are 1165 entries (variables) so I dont really want to have go into each one and change the width, type etc etc.I hope this makes sense!Many thanksLaz |
|
|
kishore_pen
Starting Member
49 Posts |
Posted - 2009-05-06 : 12:07:06
|
| try for bcp or bulkinsert options, for more info see SQL BOL. |
 |
|
|
|
|
|
Export to predefined ascii map