Click here to Skip to main content
15,067,832 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
My Question is

we have two package deployment modes that is
--SQLServer Deployment
--File System Deployment

In these two modes which was giving better security ,
what is reason and how it will give better security?

can u please anybody give me detail answer ..............
Kuthuparakkal 5-Aug-13 23:32pm

1 solution

With SSIS packages, the security is the same with SQL Server and File System deployments. The deployment is used for storage and update purposes. If you have a package stored in SQL Server, then anytime you make any changes, you need to deploy it to the server. If you a file system package, you make some modifications without having modify the package and redeploy it. We do this but using a package stored on the file system and update a configuration file.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900