February 2, 2012 at 11:04 am
I'm getting:
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.
But I am running SQL Server Standard.
So...why am I getting this message and How can I get rid of it?
February 2, 2012 at 11:31 am
Hmmmm... I always thought you needed enterprise edition to save them.
The probability of survival is inversely proportional to the angle of arrival.
February 2, 2012 at 12:31 pm
sturner (2/2/2012)
Hmmmm... I always thought you needed enterprise edition to save them.
No, I have multiple dedicated SSIS Servers and some of them have Standard Edition, where we can save the SSIS packages..
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
February 2, 2012 at 12:32 pm
How are you saving the SSIS package, (from Bids or from SSMS or how?), that might help a little in troubleshooting..
Also, where is the SSIS package residing now?
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
February 2, 2012 at 12:47 pm
Bru Medishetty (2/2/2012)
How are you saving the SSIS package, (from Bids or from SSMS or how?), that might help a little in troubleshooting..
I can't save it, it won't let me
Also, where is the SSIS package residing now?
No where (because I can't save them). I have to start afresh each time
February 2, 2012 at 12:59 pm
You mean, you create SSIS package afresh in BIDS every time? Are you sure you have necessary permissions on the folder location (most commonly the local drive) where you are saving the SSIS packages?
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
February 2, 2012 at 1:02 pm
My guess is that the OP is trying to save an SSIS script generated using SSMS import/export wizard, not BIDS. Am I correct? If I am, which options are you selecting; i.e. protection level, file system, etc?
Jared
CE - Microsoft
February 2, 2012 at 1:04 pm
I guess that... I was checking what's the OP is doing. Will have to wait for the OP's response..
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
February 2, 2012 at 1:06 pm
Bru Medishetty (2/2/2012)
I guess that... I was checking what's the OP is doing. Will have to wait for the OP's response..
Just noticed, it's pretty clear from the error that it is import export wizard 😉
Jared
CE - Microsoft
February 2, 2012 at 1:07 pm
Yes..
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
February 2, 2012 at 1:13 pm
SQLKnowItAll (2/2/2012)
My guess is that the OP is trying to save an SSIS script generated using SSMS import/export wizard, not BIDS. Am I correct? If I am, which options are you selecting; i.e. protection level, file system, etc?
Yes to the import/export wizard question. As for options, I am never prompted for them. I'm simply told "oh, by the way, you can't save this!" along the way to doing the actual import/export. There is also no obvious place for me to try to save anything.
I attached a screenshot
February 2, 2012 at 1:20 pm
It is the version of SSIS that you have installed on your machine., I believe. Not the server you are connecting to.
Jared
CE - Microsoft
February 2, 2012 at 1:22 pm
I second Jared's thoughts
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
February 2, 2012 at 1:30 pm
SQLKnowItAll (2/2/2012)
It is the version of SSIS that you have installed on your machine., I believe. Not the server you are connecting to.
OK, I just have the one that came with my SSMS install. I never thought it had anything to do with the servers I'm connecting to.
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply