Excel File Data Import issue in SQL

  • 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.

  • 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?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • 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.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply