Hi,

Can anyone of you please advise for below requirement.

1 How to get the desired output colums into Excel file without having 'copy of column/unwanted columns' in destination file.

2. How to override the existing file in excel destination.

Thanks,

Srinivas K

Hi Srinivas,

Re #1: a Data Transform Task that has Excel as destination allows to map the necessary columns http://oakdome.com/programming/SSIS_DataTransform.php

Re #2: You simply delete the Excel file as the 1st step, you may under circumstances set to delay validation of the Excel Destination (in its properties).

Hi Srinivas,

If I understand correctly, you want to load data from OLE DB Source to an Excel file. The 'copy of column' is a converted column from Data Conversion Transformation. The 'unwanted columns' is column from OLE DB Source that doesnt need to load to Excel file.

If in this scenario, we can just select the needed column in the OLE DB Source to avoid 'unwanted columns'. If the converted column is needed, we can directly load the column to a corresponding destination column. Because the destination column name can be different from the converted column name, it is only related to the Excel file.

As to your second question, Im confused by the reason why you need to override the excel file. Because the data is load to a worksheet in a excel file, we can directly add a new worksheet in the excel file. If you need to override the worksheet in Excel Destination, the answer is nope. But we can use Script Component before the Excel Destination to write script to delete the worksheet ahead.

Thanks,
Katherine Xiong