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 |
|
pssheba
Yak Posting Veteran
95 Posts |
 Posted - 2008-07-27 : 09:19:03
|
| Hi everyone,I try to export data from OLE DB source to a flat file destination with fixed size columns and i get a first row with titles (as defined) but also data the should be at the beginning of the first data row (second row of th flat file.The rest of the rows are longet then i defined and the columns are nor in a consistent position.At the connection manager i defined the excat length of a row and eace column. I matched columns of the OLE DB with the tables that are of the same width and types. I signed: "column names at the first row" and format of "fixed size" Why do i get that mess as result ?ThanksThakks |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2008-07-27 : 09:26:26
|
| It sounds like something is wrong with your carriage return/line feedMike"oh, that monkey is going to pay" |
 |
|
|
pssheba
Yak Posting Veteran
95 Posts |
Posted - 2008-07-27 : 09:38:49
|
quote:
Originally posted by mfemenel
It sounds like something is wrong with your carriage return/line feedMike"oh, that monkey is going to pay"
Hi Mike,I didnt add any cr/lf. How do you add that when exporting table ?Thanks |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-27 : 15:15:06
|
| Did you specify row terminator and how? |
|
|
|
|
|
|
Export fro OLE DB to flat file destination