Hey eb
I am clearing the contents of one excel sheet using activex script
(clearcontents()).

Then transferring new data to that sheet using data transformation task.

Unfortunatly that data is positioned in the sheet, below the range i had
cleared befor,instead of replacing the empty rows there.

Is there a way to set the range for that data in the sheet
using the data transformation task or i should do that insertion using
another activex script (where i could set the insertion range explicitly?)

TIA
Rea