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




Related Articles :

  • No Related Articles Found

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 |