Post reply

Error Code: DTS_E_PRODUCTLEVELTOLOW

  • September 3, 2009 at 10:53 am

    #135300

    Hi,

    Executing an SSIS package from SSIS Server by right clicking on the package within SSMS and choosing EXECTUE PACKAGE throws the following error:The product level is insufficient for component "Unicode to Non-Unicode Data Conversion"

    Executing the package from within BIDS or delegated to a job within SSMS works smoothly.

    Can someone explain the technical reason behind this?

    Thanks

  • September 3, 2009 at 11:12 am

    #1048931

    Most likely the machine you're trying to run the package from doesn't have Integration Services installed on it.

    See http://msdn.microsoft.com/en-us/library/aa337371.aspx

  • September 3, 2009 at 11:18 am

    #1048939

    Hi Old Hand,

    Let me first thank you for the provided link.

    Now the environment set up within I operate is as follows.

    My machine is only loaded with sql server client tools such as: SSMS, SSBIDS, SQL Profiler and so on.

    After saving a copy of the SSIS package onto the server and connecting to the server using SSMS should the package not be executed on the server and referencing all components registered on the server?

    Thanks

  • September 4, 2009 at 3:20 am

    #1049266

    You need SSIS installed on your machine.

    Ells.

    😎

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply