Excel Source in SSIS
-
Hi All,
I have very simple SSIS Package, ready data from Excel (.xlsx) and transfer into SQL. From BIDS package is running fine without any problem, now i wants to schedule this package through SQL Server Agent. Every time I run this package giving me error. Below is the error that I am getting 99% of time.
Class not registered. If someone can guide me how i can attached tif or gif file, I will attached error picture.
Please guide me if anyone run it to this type of problem.
Thank You.
-
Below the post textbox, there's a section for Attachments. You can use that.
(See the attached image)
-
You will need to install the oledb driver for excel on the server where sql server agent is running. Not sure which version you will need but have a look at http://www.microsoft.com/en-au/download/details.aspx?id=13255 (this is a link for the download from Microsoft)
-
rocky_498 (10/22/2014)
Below is the error that I am getting 99% of time.Class not registered.
What error do you get 1% of the time?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP -
Hi All,
Thank You so much happycat59, it solve my problem. This question answer by happycat59.
I am so sorry Koen Verbeeck, I didn't pay attention on 1% error, my total Concentration on 99% of error.
Thank You.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply