Click here to Skip to main content
14,488,995 members
Rate this:
Please Sign up or sign in to vote.
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

Rate this:
Please Sign up or sign in to vote.

Solution 1

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, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100