Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Product Level Too Low?

Status
Not open for further replies.

AlexCuse

Programmer
Apr 13, 2006
5,416
US
Hi All,

I am having a problem running DTS packages on one of our servers (Standard Edition). I'm getting 'product level too low' errors on even basic components like Excel/Flat File data sources and data conversion tasks. This happens with any package (but they will run from Visual Studio).

I have looked around, and it seems the culprit is usually teh SSIS component not being installed on the server. But our networking guy (who I sort of share DBA duties with, with him handling anything that requires direct access to the server) tells me that it is in fact installed. I can see that the services are running and what not as well.

Is there anything else you guys have run into that would cause this problem? The packages are stored in MSDB, if that is relevant.

I am going to use DTS for now (all our production databases are still on 2000) but I would like to get this working in the future.

Any insights greatly appreciated.

Thanks a lot,

Alex



[small]----signature below----[/small]
With all due respect, Don Bot, I don't think we should rely on an accident happening. Let's kill him ourselves.

Ignorance of certain subjects is a great part of wisdom
 
If your machines are 64bit the jet drivers for Excel, Access, etc are only 32bit. There is a flag within the packages which will need to be flipped to use the 32bit driver.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)
[noevil]
 
Nope, all 32 bit hardware. Given how much that has been asked on here lately I probably should have mentioned that. Thanks for the reply though Denny!

Someone pointed out to me yesterday while the site was down that I needed to have the SSIS component installed on the client machine as well.

I had developer's edition on my PC already, but no SSIS. After installing SSIS on my machine I was able to execute the packages from SSMS and more importantly via a job from t-sql.

I will do some digging today to see if the packages will run alright from a computer that is not running a local instance of SQL Server.

[small]----signature below----[/small]
With all due respect, Don Bot, I don't think we should rely on an accident happening. Let's kill him ourselves.

Ignorance of certain subjects is a great part of wisdom
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top