Hi, I am trying to use a File System Task within a SSIS package to copy
and rename a group of files. When I run the package from the Visual
Studio GUI it completes with no errors. However when I try to run it
via a SQL Server 2005 Job it fails with the following message:

The task "File System Task" cannot run on this edition of Integration
Services. It requires a higher level edition.

The directories that I am copying from and to both reside on the same
machine as the SQL Server, and I am running the SQL Server Agent using
an administrator account. I will need to run this using network
directories at some point, I was just trying to limit the number of
variables that could be causing the problem.

Any help would be greatly appreciated.

I believe this is a version problem. Read it somewhere some time ago. There
are different version of SQL Server 2005, like there where in 2000 (standard,
personal, msde). I believe that if you have SQL Server 2005 MSDE then it is
not possible to schedule the command line executable of SSIS as a job.

No quite sure though... Perhaps googling on this might help you further.

Thanks for the post. To follow up, I am able to run SSIS packages as
SQL Server Agent jobs if they do not involve a file system task.

Also I running 9.00.1399.06 RTM Workgroup edition of SQL Server 2005.

Frans van Bree wrote:

Thanks for the post. To follow up, I am able to run SSIS packages as
SQL Server Agent jobs if they do not involve a file system task.

Also I running 9.00.1399.06 RTM Workgroup edition of SQL Server 2005.

Frans van Bree wrote:

Frans van Bree wrote:
You can compare the editions at
http://www.microsoft.com/sql/prodinf...-features.mspx

Only the standard and enterprise editions come with Integration
Services (there're also express, developer and workgroup editions).

The enterprise edition additionally has Integration Services Advanced
Transforms, but I don't think that the file system task belongs into
this group

greetings,
Gerald

I have the Standard edition installed. I can run the package just fine
from Integration Services GUI, its just when I go to an Agent job that
things stop functioning.

Gerald Aichholzer wrote:

I have the Standard edition installed. I can run the package just fine
from Integration Services GUI, its just when I go to an Agent job that
things stop functioning.

Gerald Aichholzer wrote:

wolf.emissar (AT) gmail (DOT) com wrote:
Try SP1 for SQL Server 2005.
May it solve your problem.

Regards
Amish Shah

Is your development machine (with the SSIS GUI) the same machine as SQL Agent
is running? I found this post on sqlserver central, perhaps that helps you
some more:

Hmm... this error seems familiar. If memory serves, this would indicate
that you're trying to run this from the command prompt instead of the BI
Studio client tools. What this means is that you have the client tools
installed on the computer you're trying to run this from, but not SSIS
itself. I believe you need to run the SQL Server installer and just install
SSIS on the computer you're trying to run this from... assuming my assumption
that you're trying to run this from the command prompt is correct.

I am running it on the same machine that the Agent is on. This box
also has SSIS installed on it.

Thanks.

Frans van Bree wrote: