unable to load excel file using SSIS [Resolved]

Posted by M123geek under Sql Server on 3/25/2016 | Points: 10 | Views : 1798 | Status : [Member] | Replies : 6
Hi all

Trying to load excel file but shows error? in SSIS




Responses

Posted by: Rajnilari2015 on: 3/25/2016 [Member] [Microsoft_MVP] [MVP] Platinum | Points: 50

Up
1
Down

Resolved
Please set the DelayValidation = TRUE on the tasks where you are importing/exporting the Excel file.

Detailed Explanation: http://www.madeiradata.com/load-data-excel-ssis-32-bit-vs-64-bit/

Hope that helps

--
Thanks & Regards,
RNA Team

M123geek, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Rajnilari2015 on: 3/25/2016 [Member] [Microsoft_MVP] [MVP] Platinum | Points: 25

Up
0
Down
What error?

--
Thanks & Regards,
RNA Team

M123geek, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: M123geek on: 3/25/2016 [Member] Starter | Points: 25

Up
0
Down
i attached the picture please check once
 Download source file

M123geek, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: M123geek on: 3/25/2016 [Member] Starter | Points: 25

Up
0
Down
yeah i got it but, datavalidation = true and also we need to convert the XLSX file to CSV file

M123geek, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Rajnilari2015 on: 3/26/2016 [Member] [Microsoft_MVP] [MVP] Platinum | Points: 25

Up
0
Down
No need for the conversion to CSV.You need to save in excel 2007 format.

--
Thanks & Regards,
RNA Team

M123geek, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: M123geek on: 3/26/2016 [Member] Starter | Points: 25

Up
0
Down
yes we need to convert i am using excel 2016.

M123geek, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response