Importing EXCEL in SSIS with Formaula

[Tareq Ali, MVP]

Dears,
I'm trying to import excel sheet using SSIS, however if there is any cell
that has formula (C1 = A1 + A2), it appears as null.

[Todd C]

SSIS deals with *data*.
"A1 + A2" is not data.

You can make sure your data pipeline includes those two columns then add a
Derived Column Transform in your Data Flow and do the calculation within SSIS.

HTHT
--
Todd C
MCTS SQL Server 2005

Post by Tareq Ali, MVP
Dears,
I'm trying to import excel sheet using SSIS, however if there is any cell
that has formula (C1 = A1 + A2), it appears as null.