Using The File System Task in SQL Server 2008 Integration Services

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
ResourceDB Directory Attributes to ReadOnly & System

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.

Pages: 1 2




Array

No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |