October 20, 2015 at 10:41 am
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.
October 21, 2015 at 12:16 am
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?
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
October 21, 2015 at 8:38 am
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