Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Mike_007
Starting Member
8 Posts |
 Posted - 2007-11-05 : 06:57:52
|
| Hi guysI am trying to create a package in BIDS that reads data from a table and exports it into a flat file (.csv).The file needs to have a row for the header and a row representing the column names as well as the data rows. My problem is:1.I need to add a value in the header row that is a count of all the data rows.2. I need to add the year and period based on the year and period in the data rows. (the year and period will always be the same in the data rows)below is an example of what I want the file to look like (it is a delimited file)1;Varese;O027200702ACT;F1_V4;BATCH;2326;test companyCUSTOMER_ID;BU_ID;YEAR_ID;PERIOD_ID;ACTIVITY_ID;SCENARIO_ID;ACCOUNT_ID;DATA_UNIT_ID;DATA_VALUE000001;ZA01000001;2007;2;01;1;70;ZAR;.04000001;ZA01000001;2007;2;01;1;912;ZAR;6080374000001;ZA01000001;2007;2;01;1;941;ZAR;-.16The value in bold represent the values that i want dynamically updated...200702 represents a concatenation of the year and period2326 represents the number of data rowsThanks a mill!Mike |
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2007-11-05 : 10:17:08
|
| You may use two select statements, 1st to get the summary data as the header, and 2nd to get the detail data, then union them together as the source for the query. |
 |
|
|
|
|
|
Exporting to file using BIDS