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
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