Hi,

  i have to load sql server data to Excel,In db the data like Address1 ,Address 2,Address 3 like that

but in excel i have to load

Address1

Address2

Address3

How to do this by using ssis??

Hi sql.anandan:

You can use the Unpivot Transformation to transpose the rows into columns.

I suggest you follow this link to achieve the desired: http://blogs.msdn.com/b/philoj/archive/2007/11/10/transposing-rows-and-columns-in-sql-server-integration-services.aspx

original data like

studentid studentname address1          address2    address3

1              scott               43,jou street    oild palin  india

if i used pivot transformation,i got data in each line

studentid studentname address

1              scott               43,jou street

1              scott               oild palin

1              scott               india

but  how to change this to like this

studentid studentname address

1              scott               43,jou street

                                       oild palin

                                       india

To remove some of the data you would need to sandwich in a Script Transformation and filter that data out in _

ProcessInputRow.

Example: http://colinkirkby.blogspot.ca/2007/01/ssis-creating-error-output-from-script.html

this link for Error output description.Can you please provide correct link