July 17, 2008 at 8:44 am
Hope I can explain this...here it goes!
I receive an excel spreadsheet with the output of telephone data. The spreadsheet has 4 columns (project, expense, amt, description).
In the past, the four columns were copied to the journal layout spreadsheet and then sent for uploading.
If it was just this data, then the SSIS is an easy source to derived column to output.
Where it gets complex is that the first 5 rows of the journal layout are set accounts that allocate a sum portion of the output of telephone data.
I have been thinking about this and started with Excel Source to output derived column to credit lines derived column to Union All to Flat File or SQL Output
My plan is flawed because my derived column tasks are using the same column headers and the union all is bombing on duplication.
For each loop container I think would not work because the data incoming is not multiple files...
Looking for ideas as to how I can import data and create its credit lines then merge...attached is output (telephone_finance) and the journal layout (UTILITYALLOC1)....
Thanks
July 17, 2008 at 8:57 am
Ok thinking about this more...is it possible I can use two Excel Sources, one the output and two the journal layout form and then merge the two?
Because really that is what needs to be done....
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply