| Groups | Blog | Home |
sql server dts : SSIS File System Task Error
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.
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. [quoted text, click to view] Frans van Bree wrote:
> 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. [quoted text, click to view] Frans van Bree wrote:
> 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.
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. [quoted text, click to view] Gerald Aichholzer wrote:
> Frans van Bree wrote: > > 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. > > > > You can compare the editions at > http://www.microsoft.com/sql/prodinfo/features/compare-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. [quoted text, click to view] Gerald Aichholzer wrote:
> Frans van Bree wrote: > > 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. > > > > You can compare the editions at > http://www.microsoft.com/sql/prodinfo/features/compare-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
[quoted text, click to view]
Frans van Bree wrote: > 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. > You can compare the editions at http://www.microsoft.com/sql/prodinfo/features/compare-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,
[quoted text, click to view] wolf.emissar@gmail.com 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: > > Frans van Bree wrote: > > > 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. > > > > > > > You can compare the editions at > > http://www.microsoft.com/sql/prodinfo/features/compare-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 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. [quoted text, click to view] > 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
I am running it on the same machine that the Agent is on. This box
also has SSIS installed on it. Thanks. [quoted text, click to view] Frans van Bree wrote:
> 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 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.
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |