DTS export to multiple spread sheets -
12-19-2006
, 01:28 PM
Experts ,
Client Data1 Data2 Date
AAAAA d1 d2 1/1/2006
AAAAA d3 d3 1/1/2006
AAAAA d4 d4 2/1/2006
AAAAA d5 d5 2/1/2006
something like this. I need to create a DTS which export data from this
TABLE and put into EXCEL with REPORT_AAAAA.XLS in this data1 & data2 &
date coulmns should display for each month it should create a Sheet
Jan(All Jan Data) Next sheet FEB all feb data. |