February 23, 2011 at 10:28 pm
Hi,
I have created a package which has to read data from Excel and load it into SQL server. I have used Excel Source which is not reading all the data present in the file. It reads them as NULL for certain rows even though data is present in the rows in the physical file. Can some one help me to find out the reason and solve the problem.
I have attached the image which shows the preview from the Excel Source in SSIS. Also attached the source file which is required to be loaded to SQL server.
Thanks in advance!!!
Regards,
Krishna Chaitanya.
February 24, 2011 at 3:51 am
This is a very, very common problem with SSIS and Excel. Did you try google, because there are literally hundreds of articles, blog and forumposts about this subject.
I'm too lazy to write the entire solution out :-), so I'll just refer you to another topic of someone with the same problem:
http://www.sqlservercentral.com/Forums/Topic1067821-147-1.aspx
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 2, 2011 at 3:24 pm
Hi,
That solved my problem. Thanks for the simple solution :-).
Cheers,
Krishna Chaitanya
March 3, 2011 at 12:17 am
KrishnaChaitanya (3/2/2011)
Hi,That solved my problem. Thanks for the simple solution :-).
Cheers,
Krishna Chaitanya
No problem, glad to help.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 12, 2011 at 3:16 pm
What's the solution?
September 12, 2011 at 3:31 pm
CooLDBA (9/12/2011)
What's the solution?
Did you read the other topic where I linked to?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply