ohio,

as for ur problem with ssis....transfering SQL Server table data into excel file, u need to do the following tasks:

1) first u need to drag and drop dataflow task in control flow panel and double click the data flow task.

2) double clicking will lead u to dataflow panel, over there drag and drop the source OLEDB for SQL task and configure the connection manager.

3) drag and drop the destination for excel task and link those two tasks.

4) do the column mapping

thats it,

just look around, u will surely be able to do this.