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.
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.
ASKER
I will try to attach the file again.
ASKER
And again.
SqlServerImport.jpg
SqlServerImport.jpg
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I am using SQL Server Standard edition.
Are you running from the server or remotely from your PC?
ASKER
Vitor-
Remotely from my PC. I have asked our SQL Server administrator to grant the db_dtsoperator role to me.
Remotely from my PC. I have asked our SQL Server administrator to grant the db_dtsoperator role to me.
ASKER
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?
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?
Unfortunately, this did not give me the ability to save the package, even after I rebooted the my computer to refresh my credentialsOk 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.
ASKER
Vitor-
My administrator added those two roles for me and I still cannot save the package.
My administrator added those two roles for me and I still cannot save the package.
ASKER
Vitor-
Do you have nay more suggestions?
Do you have nay more suggestions?
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.
ASKER
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.
sorry but attachment is missing.
Thanks
Rainer