August 10, 2011 at 5:48 pm
I have 3 data flows that need to write to the same csv file. The problem thats occurring right now is that every job appends the header to the csv file. So I end up with 3 headers in 3 distinct locations. I found http://www.sqlservercentral.com/Forums/Topic685042-148-1.aspx
but it wasn't much help to me since his solution wasn't very descriptive.
Any help would be much appreciated. Thanks!
August 11, 2011 at 7:44 am
what would probably work for you is to use two seperate connection managers to the same flat file.
in the first one, select the option to include column headers, and also to overwrite contents of file, so you start from scratch. use this connection manager for your first data flow task.
then, for the other two data flow tasks, use the second connection manager. in this one, choose no column headers, and to not over-write the contents of the file.
August 11, 2011 at 8:44 am
That sounds like a solid solution. I'll try to implement it today. Thank you
edit: works.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy