Hi,
I've many rows and I want to split them in many columns, with SSIS.
I've this scenario:

INPUT TABLE

id            date
--------------------
1      2006-02-04
1      2006-03-08
1      2006-10-15
2      2006-03-07
2      2006-09-17

OUTPUT TABLE

id         date1              date2            date3
1      2006-02-04    2006-03-08     2006-10-15
2      2006-03-07    2006-09-17          null

How kind of instrument I must use????

Thanks in advance
Anja

try creating a dataflow task and using the PIVOT transformation
Hope this helps.

Foreign Key may cause multilple cycles
Bulk Insert from Excel
Sort Numbers in Nvarchar As Numbers
Orders Per Hour Count
How do I filter out unwanted rows by only one different column?