The Confounded DTS_E_PRODUCTLEVELTOLOW Error

Here is a post that I hope will help some poor fool save a lot of time.

This is the situation I found myself in:
Sandbox environment:
1) Within Visual Studio, Built and executed the SSIS project pointed at the sandbox database – no errors.
2) Within Visual Studio, Built and executed the SSIS project pointed at the user acceptance testing database – no errors.

User acceptance environment:
1) Deployed package to Integration Services and validated package without execution – no errors.
2) Executed deployed package, received a DTS_E_PRODUCTLEVELTOLOW error on the first component.

After reading forums and many failed attempts to resolve the problem I found that SSIS attempts to run on the computer on which you are using management studio. That means that if you are executing a package on a remote sql server from a machine that doesn’t have MSSQL installed it will fail. Instead, execute the package from a job on the remote SQL Server, install MSSQL on your execution platform, or install management studio on the remote SQL Server and execute the package from there.

Lastly, shouldn’t DTS_E_PRODUCTLEVELTOLOW actually be DTS_E_PRODUCTLEVELTOOLOW?

Leave a Reply

Your email address will not be published.

5 + 2 =