Writing to a text file with different row formats

I want to create a file from data within SQL that looks similar to this.

a,b,c
d,e,f,g,h,i
j,k,l,m,n,o
p,q,r
s,t,u,v,w,x
.....

Basically there would be a "header" row (3 fields in this instance) with a
number of detail lines below it (each with 6 fields in this instance). The

Is there anyway to do this in SSIS?  or just within SQL, in general?

Thanks

Steve:With a different number of header columns than you have columns in

Steve:
With a different number of header columns than you have columns in the
detail kind of violates the basic rules of databases. I have tried importing
data simila to this in layout, that some other organization has labeled "CSV"
and SSIS just does NOT like it. It bombs out every time. It is not a true CSV
data file.

To get it to work you would need to write your own customized Script Task as
a Destination adapter in the data flow.

Good Luck.
=====
Todd C