Dynamic mapping from Flat File Destination

  • 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

  • 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

  • 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 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply