Excel File Data Import issue in SQL

• rocky_498

  SSCertifiable

  Points: 6532

  More actions

  October 20, 2015 at 10:41 am

  #301661

  Hi All,

  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.

  Thank You.

• Phil Parkin

  SSC Guru

  Points: 247131

  More actions

  October 21, 2015 at 12:16 am

  #1834532

  What do you mean by this?

  If I try to try to import same modified Excel file through C#

  Is this a separate application that you are talking about?

  ---

• rocky_498

  SSCertifiable

  Points: 6532

  More actions

  October 21, 2015 at 8:38 am

  #1834699

  I am calling my SSIS Package through .Net. User will pick up the file through UI and hit submit after hit submit SSIS Package executed.