| Charles Wang[MSFT] 2006-11-10, 12:12 am |
| Hi Michael,
I understand that your SSIS package could not run under your client PC with
the following error:
"The task ... cannot run on this edition of integration services. It
requires a higher level edition."
If I have misunderstood, please let me know.
Most tasks require installation of SSIS (and thus a SQL license) to run.
Without SSIS install, with just Tools install, user can design and debug
packages, but can't run packages stand-alone. Additinally some components
(Like Fuzzy Lookup) require Developer or Enterprise License. So the message
is displayed in two situations:
a. SSIS was not installed. Only tools was installed on the machine where
package is running.
b. User has a Standard Edition of SQL Server and uses a component that
requires Developer/Enterprise Edition.
You can design and debug packages on your client computer, however if you
want to run the package under your client PC, the installation of SSIS and
the apposite edition are required.
For the support features of different editions of SQL Server 2005, you may
refer to the section "SQL Server 2005 Integration Services Features" in
this article:
http://www.microsoft.com/sql/prodin...e-features.mspx
If you have any other questions or concerns, please feel free to let me
know. It is my pleasure to be of assistance.
Charles Wang
Microsoft Online Community Support
====================
====================
==============
When responding to posts, please "Reply to Group" via your newsreader
so that others may learn and benefit from this issue.
====================
====================
==============
This posting is provided "AS IS" with no warranties, and confers no rights.
====================
====================
==============
|