How To Save SQL Server 2012 Import Data Package

While using the Import Data wizard within SQL Server Management Studio, when I get to the Save and Execute Package screen (see attached file), the Save SSIS Package portion (outlined in red) is missing. I had our SQL Server support team grant me INSERT permissions on the msdb database but I still don't have the ability to save the package.
LVL 16
Chuck WoodAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rainer JeschorCommented:
Hi,
sorry but attachment is missing.
Thanks
Rainer
Vitor MontalvãoMSSQL Senior EngineerCommented:
Apart from the missing attachment.
I had our SQL Server support team grant me INSERT permissions on the msdb database but I still don't have the ability to save the package.
The permission required should be granting db_dtsoperator role to your user.
Chuck WoodAuthor Commented:
I will try to attach the file again.
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

Chuck WoodAuthor Commented:
And again.
SqlServerImport.jpg
Vitor MontalvãoMSSQL Senior EngineerCommented:
The SAVE option isn't available on SQL Server Express Edition. Check if is that edition that you're using.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Chuck WoodAuthor Commented:
I am using SQL Server Standard edition.
Vitor MontalvãoMSSQL Senior EngineerCommented:
Are you running from the server or remotely from your PC?
Chuck WoodAuthor Commented:
Vitor-
Remotely from my PC.  I have asked our SQL Server administrator to grant the db_dtsoperator role to me.
Chuck WoodAuthor Commented:
Vitor-
My administrator said "In SQL 2012, there is db_ssisoperator instead of db_dtsoperator" and he granted me this permission. Unfortunately, this did not give me the ability to save the package, even after I rebooted the my computer to refresh my credentials. Any ideas?
Vitor MontalvãoMSSQL Senior EngineerCommented:
Unfortunately, this did not give me the ability to save the package, even after I rebooted the my computer to refresh my credentials
Ok but there's no need to reboot. Just close the connection and open new one.
There are two more roles related to SSIS and with more permissions: db_ssisadmin  and db_ssisltduser. He can give the maximum permissions (db_ssisadmin) so you can check if it works. Remember that you don't need to reboot.
Chuck WoodAuthor Commented:
Vitor-
My administrator added those two roles for me and I still cannot save the package.
Chuck WoodAuthor Commented:
Vitor-
Do you have nay more suggestions?
Vitor MontalvãoMSSQL Senior EngineerCommented:
Sorry but no. The only thing that is coming to my mind is that you're using SQL Express but you already told me that you're using Standard Edition.
Chuck WoodAuthor Commented:
We found out that, although we installed SQL Server Standard Edition on my client computer, because I had previously installed SQL Server Express Edition on the computer, SQL Server Management Studio was preventing the saving of import packages. You were correct with your solution even though we did not see how that could be the problem.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.