October 14, 2010 at 9:02 am
Hi all,
here is my problem. I have SQL 2005 64-bit system. SSIS package, very simple, just insert data from DBF and Excel files into database.
If i run package manually, it works fine. However, If I schedule it, SQL Job fails with error Class not registered.
Could anyone help? Let me know if more info needed.
Thank you very much
October 14, 2010 at 11:13 am
What edition of SQL Server are you using? Express, Workgroup, Standard, Enterprise/Dev?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
October 14, 2010 at 11:26 am
Go it....thanks
I had to use DTExec.exe instead of running as SSIS package.
October 15, 2010 at 12:10 pm
That'll make a difference! Glad you worked it out.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply