TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
arasu selvaraj
1.4k
296
4.8k
I am executing SSIS package through stored procedure
Aug 22 2016 8:07 AM
" Description: SSIS Error Code DTS_E_OLEDB_EXCEL_NOT_SUPPORTED:
The Excel Connection Manager is not supported in the 64-bit version of SSIS, as no OLE DB provider is available.
End Error
Error: 2014-09-30 05:52:58.11
Code: 0xC020801C
Source: Load Benefit String Info Excel Source [926]
Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.
The AcquireConnection method call to the connection manager "Excel Connection Manager" failed
with error code 0xC00F9304. There may be error messages posted before this
with more information on why the AcquireConnection method call failed. "
SSIS package loads the excel data and dumps into sql table. This package runs correctly when run through manual but it didnt work when called from stored procedure.
If anybody aware of this error please do let me know..
Thanks in Advance.
Reply
Answers (
2
)
Convert Column value into Number of rows
How to reply in the forum