January 7, 2011 at 8:18 am
Hi everybody, I have a flat file destination but this change depending from the OLE DB SOURCE. Someone know how mapping dynamically the column name for the data in the flat file destination.
Thanks by your help!
January 7, 2011 at 9:20 am
You'll probably have to use a script object to write the text file instead of a data flow to export to it.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 7, 2011 at 10:00 am
Everybody talk me about a script, can you tell me some tips or steps of how I can do it this?
Thanks by your help
January 10, 2011 at 7:09 am
I'd use VB.NET to create a text file, and then step through a dataset row by row and write the data into the file. It's pretty easy to do. It's not as fast and efficient as a regular text export, but it allows you to have a variable number of columns.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply