I have created a package that exports data to an excel file. The column
headers (column A, column B, column C, etc) are currently in row 1 of the
file. The data populates in the file starting in row 2 and going as far as
needed.

Is it possilbe to transpose the columns and rows and have my column headings
move to column A and have the titles in row 1, row 2, row 3, etc. and then
have the data populate in column B, column C, etc - as far as needed?

I know you can do a paste special and transpose columns and rows, but can
you define a dts package to export this way?

Thanks in advance.