SSIS 2008 - Adding lines when using Flat File Destination

Question

Viewing 7 posts - 1 through 6 (of 6 total)

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

Suresh Arumugam Hall of Fame Points: 3370 More actions · Answer 1

GUYS, Please help me to get my above request solved.

Thanks in advance,

Regards,

Suresh

Regards,
Suresh Arumugam

davoscollective SSCertifiable Points: 6405 More actions · Answer 2

*edit* - I realise this is in the SSIS forum, my response didn't take that into account so deleted.

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 3

The first lines need to be added through a script task.

After that, use a dataflow with flat file destination to append the data to the existing flat file.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Suresh Arumugam Hall of Fame Points: 3370 More actions · Answer 4

Thanks Koen. That's a good point. I will try to add the top portion through script and use the Flat File destination option

to add the below Item details.

By the way., is there a way to append data in the existing Flat file when using Flat file destination?

Regards,

Suresh

Regards,
Suresh Arumugam

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 5

In the Flat File Destination, you have a checkbox for "Overwrite data in the file". I assume if you leave this blank data will be appended.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Suresh Arumugam Hall of Fame Points: 3370 More actions · Answer 6

ok. I wil test that option.

Thanks for your time Koen.

Regards,

Suresh

Regards,
Suresh Arumugam