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 |
|
NeilG
Aged Yak Warrior
530 Posts |
 Posted - 2009-06-11 : 09:34:44
|
| Hi, Im trying to get the following but for some reason this appears not to work, I have an oldb source which is connect straight to a table to extract everything from that table.I then have a Flat file destination file,everthing is mapped and set to column delimiter ',' etc but however when i extract the file only the data is return with not column header.I've tried clicking the first row as header in the flat file connection but this just then has the first row of the data as the column headings and then you can't map the columns correctly.Please help guys |
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2009-06-11 : 09:57:05
|
| Help please |
 |
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2009-06-11 : 10:08:18
|
| Ignore it yet again i appear to have figured this out before i get a reply, think i need to start trying more before posting on here and wasting your guys time Cheers anyway to anyone that started having a look |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-06-11 : 11:31:11
|
Maybe then you can post your solution here for the next one...?
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
|
|
Column names as headers in flat file destination