I am facing a very weird issue. I have source Excel(.xlsx) file and SQL table Destination. Excel file has 325 records Without any changes in Excel file, if I try to import through BIDS or call this .dtsx package from c# working fine and imported 325 records into SQL Table. However, If I change something in Excel i.e time field change and change font into Red colour, through BIDS if I try to import 325 records into SQL no issue 325 imported successfully. If I try to try to import same modified Excel file through C#, it is not importing those records that I modified in Excel (Modified date and change font color to Red).
Is anyone face this type of issue before? Please advise.