unable to load excel file using SSIS [Resolved]

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

Hi all

Trying to load excel file but shows error? in SSIS

[Resolved]

Reply | Reply with Attachment

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

1	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

0	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

0	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

0	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

0	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

0	yes we need to convert i am using excel 2016. M123geek, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts