How to share SSIS Package?
I have read-only access to a database (eg DB1) via MS SQL Server Management Studio (SSMS). I created an SSIS package in Visual Studio that exports all the tables in the database, DB1, to Excel. Now, I'm going to install MS SSMS onto another user's computer and want to share the SSIS package. What is the best way to share the project without deploying the project to an integration services server? I don't have access to one.
ASKER
I executed the SSIS package from a local copy of Visual Studio. I don't want this other user to need to download it. Can the other user run the package without Visual Studio and without access to an integration services server?
What is the best way to share the project without deploying the project to an integration services server? I don't have access to one.
Without access, you could not install/deploy dtsx project into integration service!
Hi,
No. First the user needs to have access on your project and then access on the package. Without that he/she cannot do anything.
Hope it helps!
Can the other user run the package without Visual Studio and without access to an integration services server?
No. First the user needs to have access on your project and then access on the package. Without that he/she cannot do anything.
Hope it helps!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
<Can the other user run the package without Visual Studio and without access to an integration services server?>
yes,
Create Sql server agent job that will run your SSIS pack and if need give access to execute this job
or schedule it
more
Schedule a Package by using SQL Server Agent
https://msdn.microsoft.com/en-us/library/gg471507.aspx
yes,
Create Sql server agent job that will run your SSIS pack and if need give access to execute this job
or schedule it
more
Schedule a Package by using SQL Server Agent
https://msdn.microsoft.com/en-us/library/gg471507.aspx
You can copy the dtsx file to the another location where you want. But how you will execute you without access? If i understand your question correctly. or do you need something else.