How to read Cell Value from Excel by using Script Task in SSIS Package-P176

SSIS Video Scenario:
How to read Cell Value from Excel by using Script Task in SSIS Package

Sometime we have to read the cell value from given Excel file and then make decision either to load that file or not or perform some actions. While back, I wrote a post How to read Excel Cell Value from Excel Sheet by using Execute SQL Task, you can check the link here. The post was shared on different forums and few people had problem with reading Date type value from Excel Cell.

As I am working on Dynamic Excel Source and Destination now a days, I thought why not to write the same post by using Script Task.

In this post, we will read the cell value from Excel Sheet by using Script Task. We will insert the value into sql table so we can take a look if we like later on. Also we will save the value of cell to variable to control next tasks or use in precedence constraint or any where in our SSIS Package.

Link to the script used in the video

SQL Server Integration Services(SSIS) Tutorial
SQL Server Reporting Services (SSRS) Tutorial
SQL Server / TSQL Tutorial
SQL Server DBA Tutorial
Team Foundation Server
Microsoft Dynamics AX

[abhisheknirwani]

Thanks Aamir for this video and I will see your next video :P

[mmichael]

Thank you so much Aamir...really great video!!!

[davesmith]

Aamir, you produce awesome videos. How do you change your connection to use a $Project db connection instead of local?

[roshini.g]

Is there any possibility to read Excel column which is coloured

[silviacargua]

No me funcionó, me sale este error: Error: El script devolvió un resultado incorrecto.

[terabyte]

How to Delete the column if all values are null

[lazykitten]

too fast. Why you are always in a hurry? Can you explain each line of the C# in more detail??? or many be just create another video explaining basics about connecting to OLEDB, ADO.NET in C# and SSIS. Without these basics, it is very hard to understand all your SSIS/C# EXCEL videos.