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 |
|
sampathreddy_g
Starting Member
1 Post |
 Posted - 2007-03-02 : 03:35:23
|
| Hi all i am new to SSIS. i want to read data from a text file and store in to a table. i am reading no, name, marks1, and marks2 from the txt file. i want to store in the data base as follows no,name, marks1,marks2,Total,avg, class. i tried it. but i can transform data to table, like no,name,marks1,marks2 to the table. i do not know how to compute total and average and class is a const like 'MCA'.how to do and what components should i use?thax in adv.gsk reddy |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2007-03-02 : 04:46:35
|
| Look at the Aggregate and Derived Column transforms. There's a lot of good info at [url]www.sqlis.com[/url] and [url]http://blogs.conchango.com/jamiethomson/[/url]Mark |
 |
|
|
|
|
|
new to SSIS