October 22, 2014 at 3:06 pm
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.
October 22, 2014 at 4:12 pm
Below the post textbox, there's a section for Attachments. You can use that. 😉
(See the attached image)
October 22, 2014 at 9:16 pm
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)
October 23, 2014 at 12:45 am
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
October 23, 2014 at 9:32 am
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