 RE: SSIS Package security -
12-10-2008
, 08:26 AM
Hi Gerhard,
For the information of setting ProtectionLevel, you can refer to this
article:
Setting the Protection Level of Packages
http://technet.microsoft.com/en-us/l...7(SQL.90).aspx
For your first question setting ProtectionLevel to ServerStorage, it
requires the prerequisite that the packages must be stored in MSDB
database. You could not edit the package protectionlevel in the BIDS,
however you can refer to the following steps to export your package to MSDB
database:
1. In BIDS, choose File --> Save Copy of your-pkg.dtsx As...
2. Fill out Save Copy of Package dialog and make sure the protection level
set to "Rely on server storage and roles for access control".
For your second question, "within the package, I run various packages that
were created by the export wizard. Do I need to change the setting on each
of those? Also, when a table has a change, these scripts fail, and I have
been unable to find a way to edit them so end up having to rebuild them.
Is there a way to edit/refresh them in this instance?"
If you need to change the setting on each of those, you may save all the
packages to your MSDB database. For the table change and your script fails,
I think that you may consider save all your SQL scripts into a file (XML)
or a table, read it first to a variable and then execute the statement
extracted from the variable value. By this way, you just need to edit your
T-SQL script outside your SSIS package. Regarding variable usage, you may
refer to the following article:
Variables How-to Topics (Integration Services)
http://msdn.microsoft.com/en-us/library/ms141105.aspx
SSIS Design Pattern - Read a DataSet From Variable In a Script Task
http://sqlblog.com/blogs/andy_leonar...design-pattern
-read-a-dataset-from-variable-in-a-script-task.aspx
Sourcing XML Data in SSIS 2005
http://blogs.msdn.com/rdoherty/archi...16/396956.aspx
Hope this helps.
Best regards,
Charles Wang
Microsoft Online Community Support
================================================== =========
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg (AT) microsoft (DOT) com.
================================================== =========
 |
Linear Mode
