"Set Global Variables" cannot run on this edition of Integration Services.
-
Hi All,
I am running SSIS Packages on a Windows Server 2003 and my DTEXEC command is runnibg as Version 9.00.1399.06 for 32-bit.
Has any one seen this error?
The task "Set Global Variables" cannot run on this edition of Integration Services. It requires a higher level edition.
Thanks in advance
S
-
sachinbb (12/24/2008)
Hi All,I am running SSIS Packages on a Windows Server 2003 and my DTEXEC command is runnibg as Version 9.00.1399.06 for 32-bit.
Has any one seen this error?
The task "Set Global Variables" cannot run on this edition of Integration Services. It requires a higher level edition.
Thanks in advance
S
What version of SQL 2005 did you install? If you use the express edition, most probably you will not be able to use all of the SSIS functionality.
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
-
It is SQL Server 2005. What is the upgrade if i need any?
thnx
-
sachinbb (12/24/2008)
It is SQL Server 2005. What is the upgrade if i need any?thnx
You will need at least standard edition.
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/ -
I have enterprise edition.
This is what i get with Help > About...
Microsoft SQL Server Management Studio
9.00.1399.00
Microsoft Analysis Services Client Tools2005.090.1399.00
Microsoft Data Access Components (MDAC)
2000.086.1830.00 (srv03_sp1_rtm.050324-1447)
Microsoft MSXML
2.6 3.0 4.0 6.0
Microsoft Internet Explorer
6.0.3790.1830
Microsoft .NET Framework
2.0.50727.42
Operating System
5.2.3790
thnx
-
sachinbb (12/24/2008)
I have enterprise edition.This is what i get with Help > About...
Microsoft SQL Server Management Studio
9.00.1399.00
Microsoft Analysis Services Client Tools2005.090.1399.00
Microsoft Data Access Components (MDAC)
2000.086.1830.00 (srv03_sp1_rtm.050324-1447)
Microsoft MSXML
2.6 3.0 4.0 6.0
Microsoft Internet Explorer
6.0.3790.1830
Microsoft .NET Framework
2.0.50727.42
Operating System
5.2.3790
thnx
Your SQL Server looks rather old. On my machine it says:
Microsoft SQL Server Management Studio9.00.3042.00
Microsoft Analysis Services Client Tools2005.090.3042.00
Microsoft Data Access Components (MDAC)6.0.6001.18000 (longhorn_rtm.080118-1840)
Microsoft MSXML3.0 5.0 6.0
Microsoft Internet Explorer7.0.6001.18000
Microsoft .NET Framework2.0.50727.3053
Operating System6.0.6001
------------------
Have you installed at least SQL 2005 SP2 ? This is mandatory SP.
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/ -
It looks to me that i need to install the SSIS on my server. I do not see it in Computer Mangement.
Please look in the attached image.
How do i install the SSIS on my server.
-
The right part of the screen is missing. This is where you should see your SSIS service. Anyway you have to initiate the SQL Server installation and include SSIS option there.
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/ -
Thanks Cozyroc,
I was under the impression that i could just run my SSIS packages with the DTEXEC command which is installed in
DTExec.exe 2005.90.1399.0
C:\Program Files\Microsoft SQL Server\90\DTS\Binn
It looks to me now that i would need the full SSIS services running on my server. Is that right?
Or could i just update my DTExec/ SQL Server 2005 to
9.00.3042.00 like yours?
How will i accomplish that if needed?
S
-
You have to install SSIS services. If you don't select the option, most of the components will not be deployed. To upgrade your version you have to download and install SQL Server 2005 SP2.
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/ -
It looks like i need to install SSIS service on to the server which i thought was installed as default. How would i just install SSIS and not affect the current SSMS 2005?
thnx
S
-
Run your SQL Server 2005 installation and select you want to modify existing installation. Select SSIS option to be installed.
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply