CODEWITHSUNDEEP
ssisrowadditionflat-file
Brno
Brno

Reputation:

SSIS: How to read flatfile and add a new row to the file

I have a text file and needs to read it and change some text and add some new text in a new row. How do I add e new row with some text in it? I now use a script component to read existing rows and change in them but I can't add a new row :-(

Thanks in advance

Regards Brno

Upvotes: 0

Views: 2339

Answers (1)

Michael Entin
Michael Entin

Reputation: 7744

To add rows, you need to change the script transfrom to asynchronous mode.

Look for "Creating an Asynchronous Transformation with the Script Component" on MSDN.

(Currently the following link works: http://msdn.microsoft.com/en-us/library/ms136133.aspx)

Upvotes: 1

Related Questions