Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...
SQL Server Forum / Services / DTS / July 2008

Tip: Looking for answers? Try searching our database.

DTS_E_PRODUCTLEVELTOLOW

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Carl Henthorn - 28 May 2008 18:33 GMT
When I run this certain SSIS package ON the server its deployed to, then it
runs fine, no worries. When I try to run the package from my Management
Studio app (on my machine) while connected to the integration services
instance of that server, I get this error:
Error: SSIS Error Code DTS_E_PRODUCTLEVELTOLOW. The product level is
insufficient for component "<flat file that data is extracted to>"

If I run this package from within Visual Studio 2005 on my machine, then it
runs fine as well.

I tried deploying the package to a different server, but I still get all the
same scenarios. Does anyone have an idea to fix this?
thanks in advance!
Reply to this Message
Pat M - City of Reno - 29 May 2008 16:51 GMT
Wow, how eerie. I just signed on to log the exact same issue as you. I
created an Export package and it ran fine but when I made it a job I got the
same message as you. Do you have to have Enterprise Edition to do this? I
will not be happy if this is so.
Signature

Regards,
Pat

> When I run this certain SSIS package ON the server its deployed to, then it
> runs fine, no worries. When I try to run the package from my Management
[quoted text clipped - 9 lines]
> same scenarios. Does anyone have an idea to fix this?
> thanks in advance!
Reply to this Message
Pat M - City of Reno - 25 Jul 2008 21:50 GMT
Here I am back trying to make this work. Carl, did you ever get yours solved?
I am going to post again for help on this one.
Signature

Regards,
Pat

> When I run this certain SSIS package ON the server its deployed to, then it
> runs fine, no worries. When I try to run the package from my Management
[quoted text clipped - 9 lines]
> same scenarios. Does anyone have an idea to fix this?
> thanks in advance!
Reply to this Message
matteus - 28 Jul 2008 08:05 GMT
On Jul 25, 10:50 pm, Pat M - City of Reno
<PatMCityofR...@discussions.microsoft.com> wrote:
> Here I am back trying to make this work. Carl, did you ever get yours solved?
> I am going to post again for help on this one.
[quoted text clipped - 15 lines]
> > same scenarios. Does anyone have an idea to fix this?
> > thanks in advance!

In SQL 2005 things are a bit different.
While in SQL2000 you can run a DTS package from your client, you can't
do it in SQL2005.
The reason is that you must have SSIS installed:
http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1650756&SiteID=17
M.
Reply to this Message
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.