Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 5777
  • Last Modified:

SSIS Error Code DTS_E_PRODUCTLEVELTOLOW, The product level is insufficient for component

Hi, Sir/Madam

When we ran a job that included a DTS package, and we got error message as following:

SSIS Error Code DTS_E_PRODUCTLEVELTOLOW, The product level is insufficient for component
"Data Conversion 1" (88).
End Error

SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED.  The Execution method succeeded, but the
number of errors raised (1) reached the maximum allowed (1); resulting in failure. This
occurs when the number of errors reaches the number specified in MaximumErrorCount. Change
the MaximumErrorCount or fix the errors.


Do you have any idea to fix that? Thanks
0
yong_wu
Asked:
yong_wu
  • 3
1 Solution
 
Chris MangusDatabase AdministratorCommented:
Make sure your SQL Server has the most current service pack applied.
0
 
i2mentalCommented:
There may be something in that step that is not supported on the version of SQL Server you're running it against. For example, it may have a fuzzy lookup component that is only available on Enterprise and Developer editions.
0
 
yong_wuAuthor Commented:
Our SQL Server current Status:

Product version:  9.00.3054.00
Product Level:    SP2
Edition:               Enterprise Edition

Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86)   Mar 23 2007 16:28:52   Copyright (c) 1988-2005 Microsoft Corporation  Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
0
 
i2mentalCommented:
Are you launching this package from your local management studio and the connections are pointing to the server? If so, what version is your local installation? Make sure that you have SSIS installed on the server.

Try remotely connecting to the server and opening the package up directly on the server. You can also import the package to the SSIS instance on the server and run it through a SQL job.
0
 
i2mentalCommented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now