January 24, 2013 at 10:25 am
I need to store results of two ssis package into one excel sheet.
columns are defined but the problem is when i run the second package it start from last row + 1 of first package result. but i need to start from first column.
Any idea??
January 24, 2013 at 11:05 am
vax09 (1/24/2013)
I need to store results of two ssis package into one excel sheet.columns are defined but the problem is when i run the second package it start from last row + 1 of first package result. but i need to start from first column.
Any idea??
What do you mean by first column?
January 26, 2013 at 12:16 pm
The Excel Destination will simply append results. It sounds like you want to update other columns in the existing data. For that you would need to combine the two package's functionalities where you join the two datasets in one Data Flow using a Merge Join Transformation and then write the combined result out to the Excel Workbook.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply