Buy Questpond's video subscriptions on
huge discount
.
Online: 1014
Home
Articles
Interviews
Forums
For Beginners
Popular Questions
ITIL Career Advice
PMP Career Advice
Career Advices
Codes
Videos
ASP.NET
ASP.NET MVC
Android Intel XDK
Sql Server
AngularJS
Bootstrap
Backbone.JS
MongoDB
LESS (CSS)
jQuery
WPF
WWF
SSIS
LightSwitch
Tutorials
News
ASP.NET MVC
|
Be Interview Ready
|
Top Performers
|
DNF MVP
|
Top Posts
|
Winners
|
Subscribe
|
Catalogs
Welcome Guest !
Register
Login
Home
>
Forums
>
Sql Server
>
Loading ...
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
Write New Post
|
Search Forums
|
Resolved Posts
|
Un Answered Posts
|
Forums Home
Hi all
Trying to load excel file but shows error? in SSIS
Attachment
[Resolved]
Reply
|
Reply with Attachment
Alert Moderator
Responses
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
Login to post response
Latest Posts
How to get the exact property name while getting error
(0)
PDB file is not showing Line Number in dot net application hosted on server
(0)
Both Strings morethan 5 letters in length end of the words one vowel and one consonent is different
(0)
how to check Any adjacent letters transposed between two strings(ex: JOHN, JHON)
(1)
can't receive data after success login ?
(1)
Implement Multi-Tenant in Azure Logic Apps
(0)
Why ASP.Net Core 7.0 Web API showing as Connection refused?
(0)
Iterating over columns of dataframe and print as rows in Python Django
(0)
More ...