6.
Drag and drop the
second “File System Task” from the toolbox to the Control Flow window and
rename it as “Copy ResourceDB LDF File” , then double click the
File System Task to open up the editor window and set the properties as shown
in the below snippet.
7.
Drag and drop the
third “File System Task” from the toolbox to the Control Flow window and rename
it as “Set ResourceDB Directory Attributes to ReadOnly & System”,
then double click the File System Task to open up the editor window and set the
properties as shown in the below snippet.
The
File System Task Editor should be configured with the details shown in the
below table.
|
Attributes |
|
|
Hidden |
False |
|
ReadOnly |
True |
|
Archive |
False |
|
System |
True |
|
General |
|
|
Name |
Set |
|
Description |
File System Task |
|
Operation |
|
|
Operation |
Set Attributes (Choose this option from the Drop-down list) |
|
Source Connection |
|
|
IsSourcePathVariable |
True |
|
SourceVariable |
User::DestinationDirectory (Choose the user variable from the Drop-down list) |
8.
Connect the
File System tasks together as shown in the below snippet.
9.
Finally, execute
the package by right clicking the FileSystemTaskExample.dtsx package
from the solution explorer and select the Execute Package option from the drop
down list. Once the package has successfully executed you will be able to see
the below screen within the control flow designer.
10.
Once the
package has successfully executed, check the properties of ResourceDB folder
and you will find that the folder attributes are set to ReadOnly as shown in
the below snippet.
]]>