Importing unformatted data
-
Hey there is a sample of my report.
It has or could have many report pages in the one file.
report page no 1
Sales report xxx xxxxxxx
cust sales qty profit
123 100 2 40
122 100 2 40
124 100 2 40
report page no 2
Sales report xxx xxxxxxxx
cust sales qty profit
123 100 2 40
122 100 2 40
124 100 2 40
xxxxxxxxxxxx
xxxx xxxxxx
Summary of report page 3
Days Sales qty profit
M 500 5 400
T 500 2 200
W 400 6 300
T 200 6 400
F 300 2 400
=============================
Total 1900 21 1700
I'd like to import in the very last line where i can get the total value of 1900
-
Okay,
I have an idea. And I think you might be able to accomplish your processing without programming. Here is what you have to do:
1. Insert data flow task.
2. In the data flow setup your data source, with the appropriate number of columns.
3. After the data source insert conditional split component. Setup the component to pass only the rows, which have as their first column the text: Total . The rest of the rows have to be ignored.
4. Insert the appropriate destination component and load the rows you receive from the conditional split.
I think this should be it in general. Give it a try and let us know how it goes.
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
Viewing 2 posts - 16 through 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply