Cannot Run on this Edition of Integration Services Error Message

Hot Topic

convert millisecond to "hh:mm:ss" format
Parameter Questions
Doesn't like a particular namespace
Incorrect Results with t-sql Query in SQL Server 2005
SQL Server 2005 Express - Upgrading will Lose Data?
Paging large result sets
ReportServer giving me a 404????
Interface not registered using Excel/mail?
sql install as default ..new registration
It doesnt execute my assemblies.

SQL Server

Linked Server connection issue
Domain - User Data Types
Planning execution of package
Dtexec Version
Implicit conversions using UDTs
dts migration
Converting a parent-child table into a genrational table / text file
table schema changes not being propagated - merge replication
return all rows function
Shading By Value

Cannot Run on this Edition of Integration Services Error Message

Hi All,

I am little new to 2005 so this may be an easy one. I have a IS package that I created on my local 32 bit machine. I have copied this package to one of our servers running SQL 2005 EE x64. The package executes fine until it gets to a VB Task at which point it errors with the message of "The Task "DefalutValues" cannot run on this edition of Integration Services It requires a higer level edition"

Is this a known bug/error that you can not build on a 32bit machine for a 64bit machine. I have set the precompilescriptINtoBinaryCode value to true.

If anyone has any suggestions please let me know.

Thank you.

Answer this question

Cannot Run on this Edition of Integration Services Error Message

  • gxhpainter

    Did you ever find a solution to this problem. I'm having the same issue.

    Thanks.

    Mitch



  • Chrisky

    I had the same issue, but in my case it was caused becuase I was connecting from my desktop client (where I had built the package) to the server where I had imported it.

    I thought it would have run under the server context but the package was obviously running under the local express edition.

    When I RDP'd the server (running enterprise edition) and ran it from there, the package ran with no problems.

  • brettman

    The message is reported in two cases:

    1. You installed just Client Tools, but did not install the SSIS in SQL setup. The Client Tools allow package to be designed and debugged, but most tasks require installing SSIS. SSIS is a separate checkbox in SQL Setup, and require SQL license for the installation machine.
    2. You have Standard SQL Server edition, and are using tasks and transforms that require Enterprise edition (a small number of tasks and transforms, like Fuzzy Lookup, etc).


  • besserer

    The same problem. The same solution.

    Server machine has sql 2005 Ent installed (+IS).

    On local machine - SMS and BIDS.

    Package created using BIDS.

    Created configurations.

    Builded.

    Transfered physicly to server machine.

    Installed using manifest file.

    When i've connected to IS from local machine using SMS and tried to execute deployed package,

    got the same error message.

    Then i RDP'ed to server machine and run package from it - everything worked just fine.



  • Cannot Run on this Edition of Integration Services Error Message
Answer this question