Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 HOw to save SSIS packages?

Author  Topic 

d934106
Starting Member

5 Posts

Posted - 2012-06-12 : 10:07:47
HI -- I installed SSMS 2008 R2 which our company uses. I need to copy some tables between servers so I use SSIS. However, just before I start a copy, I get this message:

"In SQL Server Express, Web, or Workgroup, you can run the package that the Import and Export Wizard creates, but cannot save it. To save packages that the wizard creates, you must upgrade to SQL Server Standard, Enterprise, Developer or Evaluation."

I'm confused by this since I do not have SQL SE, Web or Workgroup installed. What should I do to get rid of this message and be able to save the packages that SSIS generates?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-06-12 : 15:46:05
as suggested by message you should upgrade to either one of the listed edition.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

Sachin.Nand

2937 Posts

Posted - 2012-06-12 : 16:14:23
quote:
Originally posted by d934106


....I'm confused by this since I do not have SQL SE, Web or Workgroup installed.



If your edition is neither of above then what edition is it ?

After Monday and Tuesday even the calendar says W T F ....
Go to Top of Page

d934106
Starting Member

5 Posts

Posted - 2012-06-13 : 10:20:02
quote:
Originally posted by Sachin.Nand

quote:
Originally posted by d934106


....I'm confused by this since I do not have SQL SE, Web or Workgroup installed.



If your edition is neither of above then what edition is it ?




The about screen says:

quote:
Microsoft SQL Server Management Studio 10.50.2500.0
Microsoft Data Access Components (MDAC) 3.85.1132
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 8.0.6001.18702
Microsoft .NET Framework 2.0.50727.3634
Operating System 5.1.2600


Go to Top of Page

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2012-06-13 : 10:25:38
run
SELECT @@Version
please and post the result here.


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-06-13 : 10:31:02
what does this return?


SELECT SERVERPROPERTY('Edition')
GO


------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

d934106
Starting Member

5 Posts

Posted - 2012-06-13 : 11:22:56
quote:
Originally posted by visakh16

what does this return?


SELECT SERVERPROPERTY('Edition')
GO





I got:

Standard Edition
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-06-13 : 15:19:34
quote:
Originally posted by d934106

quote:
Originally posted by visakh16

what does this return?


SELECT SERVERPROPERTY('Edition')
GO





I got:

Standard Edition



then you should be able to save package. Are you trying to launch export import wizard from another remote sql server?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

d934106
Starting Member

5 Posts

Posted - 2012-06-13 : 15:21:51
quote:
Originally posted by visakh16

quote:
Originally posted by d934106

quote:
Originally posted by visakh16

what does this return?


SELECT SERVERPROPERTY('Edition')
GO





I got:

Standard Edition



then you should be able to save package. Are you trying to launch export import wizard from another remote sql server?




Nope -- I launch it from the SQL Server I currently have open in SSMS
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-06-13 : 15:31:19
quote:
Originally posted by d934106

quote:
Originally posted by visakh16

quote:
Originally posted by d934106

quote:
Originally posted by visakh16

what does this return?


SELECT SERVERPROPERTY('Edition')
GO





I got:

Standard Edition



then you should be able to save package. Are you trying to launch export import wizard from another remote sql server?




Nope -- I launch it from the SQL Server I currently have open in SSMS


Thats fine. But is that server instance installed in your machine or is it a instance running in another server box?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

Sachin.Nand

2937 Posts

Posted - 2012-06-13 : 15:49:18
Looks very likely that you have SSMS express edition installed.Do a SSMS reinstallation from the SQL Server standard edition set up.

After Monday and Tuesday even the calendar says W T F ....
Go to Top of Page

d934106
Starting Member

5 Posts

Posted - 2012-06-13 : 16:53:35
that DID it! Thanks so very much!!
Go to Top of Page
   

- Advertisement -