Problem solved. I posted at TechNet forum and got an answer here. Actually, I was missing a SET NOCOUNT ON statement.

Cheers,

Thanks for your reply Chris, I was already using the derived column transformation and was trying to find if there is any other solution.

Have a nice day.

Regards,

Thanks for your reply. I already tried this but when I execute the SSIS task, it starts populating the excel rows after the last row in which I pre-wrote the...

Thanks for your detailed reply. Its a nice idea to write formulae columns before populating the excel sheet so that the calculated columns give the correct values once the data...

Hmmm. I think I will have to do my calculations in the SQL query and just write the result set to excel.

Hi Robert,

Like SQL server pre-compiles stored prodecures, does it also pre-compiles UDFs or views.

Regards,

Mehroz.