We help IT Professionals succeed at work.

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.
Comment
Watch Question

CERTIFIED EXPERT
Most Valuable Expert 2013
Awarded 2012

Commented:
Hi,
sorry but attachment is missing.
Thanks
Rainer
Vitor MontalvãoIT Engineer
CERTIFIED EXPERT
Distinguished Expert 2017

Commented:
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.

Author

Commented:
I will try to attach the file again.

Author

Commented:
And again.
SqlServerImport.jpg
IT Engineer
CERTIFIED EXPERT
Distinguished Expert 2017
Commented:
The SAVE option isn't available on SQL Server Express Edition. Check if is that edition that you're using.

Author

Commented:
I am using SQL Server Standard edition.
Vitor MontalvãoIT Engineer
CERTIFIED EXPERT
Distinguished Expert 2017

Commented:
Are you running from the server or remotely from your PC?

Author

Commented:
Vitor-
Remotely from my PC.  I have asked our SQL Server administrator to grant the db_dtsoperator role to me.

Author

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ãoIT Engineer
CERTIFIED EXPERT
Distinguished Expert 2017

Commented:
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.

Author

Commented:
Vitor-
My administrator added those two roles for me and I still cannot save the package.

Author

Commented:
Vitor-
Do you have nay more suggestions?
Vitor MontalvãoIT Engineer
CERTIFIED EXPERT
Distinguished Expert 2017

Commented:
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.

Author

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.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.