User right for SSIS

%3CLINGO-SUB%20id%3D%22lingo-sub-1131806%22%20slang%3D%22en-US%22%3EUser%20right%20for%20SSIS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1131806%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3ESo%20I%20learned%20that%20to%20connect%20to%20Integration%20Services%20server%20type%20from%20SSMS%20you%20need%20to%20be%20admin%20on%20your%20computer.%20Well%2C%20I%20am%20not%20and%20the%20IT%20wants%20to%20keep%20it%20that%20way.%20To%20work%20with%20SSIS%20and%20create%20packages%2C%20does%20one%20need%20to%20be%20admin%20or%20you%20can%20work%20with%20SSIS%20even%20without%20having%20to%20connect%20to%20it%20from%20SSMS%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1131806%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EIntegration%20Services%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1136981%22%20slang%3D%22en-US%22%3ERe%3A%20User%20right%20for%20SSIS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1136981%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F70866%22%20target%3D%22_blank%22%3E%40Nima%20Mohandesan%3C%2FA%3E%26nbsp%3BWhat%20is%20your%20reason%20for%20connecting%20to%20SSIS%20from%20SSMS%3F%26nbsp%3B%20There%20isn't%20much%20you%20can%20actually%20do%20from%20SSMS%20with%20SSIS%20apart%20from%20view%20the%20packages%20stored%20in%20the%20file%20system%20or%20msdb%20and%20execute%20or%20upgrade%20them.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20create%20packages%2C%20it%20is%20common%20to%20use%20Visual%20Studio%20or%20SQL%20Server%20Data%20Tools%20to%20author%20packages%20and%20then%20deploy%20these%20to%20a%20server.%20You%20can%20then%20execute%20these%20from%20SSMS%20using%20the%20SISS%20catalog.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Contributor

Hi,

So I learned that to connect to Integration Services server type from SSMS you need to be admin on your computer. Well, I am not and the IT wants to keep it that way. To work with SSIS and create packages, does one need to be admin or you can work with SSIS even without having to connect to it from SSMS? 

1 Reply
Highlighted

@Nima Mohandesan What is your reason for connecting to SSIS from SSMS?  There isn't much you can actually do from SSMS with SSIS apart from view the packages stored in the file system or msdb and execute or upgrade them.

 

To create packages, it is common to use Visual Studio or SQL Server Data Tools to author packages and then deploy these to a server. You can then execute these from SSMS using the SISS catalog.