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 |
|
ismailc
Constraint Violating Yak Guru
290 Posts |
 Posted - 2009-03-27 : 09:36:07
|
| Hi, I need help. I have an error csv file and it writes successfully after one data flow task. But when at another task how do I append the new rows to the existing file? It always overwrites, tried raw file destination & set to append but not luck. Please assist, Regards |
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2009-03-27 : 09:39:57
|
| Is the other task part of the same package? |
 |
|
|
ismailc
Constraint Violating Yak Guru
290 Posts |
Posted - 2009-03-30 : 04:52:33
|
| Hi,One package with different dataflows, I have it going to an extentwith setting flat file destination overwrite to false, but the file can be created at various dataflow tasks so i set the connection to first row have column header - so what happens it duplicates the header.Regards |
|
|
|
ismailc
Constraint Violating Yak Guru
290 Posts |
Posted - 2009-03-30 : 05:15:31
|
| Hi,I got it going using flat file destination with overwrite set to false & connection with no headers. Thank YouRegards |
|
|
|
|
|
|
SSIS, Append CSV File