From the course: SQL Server Integration Services

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Modify file attributes

Modify file attributes - SQL Server Tutorial

From the course: SQL Server Integration Services

Start my 1-month free trial

Modify file attributes

“

- [Instructor] So, let's add one more File System Task to the Control Flow, and we'll use it to set the status of the copied files to read-only. I'll double-click it one more time over here, and we'll drag it into position, then I'll double-click on the icon to open up the Editor. For the SourceConnection, we don't need to create a new one, because we could just use the same PeopleCopy.csv that we've already created. I'll change the Operation to Set Attributes. And up here at the top, I'll change the ReadOnly Attribute to True. That completes this task, I'll press the OK button, and that returns us back to the design surface. The last step is to connect all these tasks together to ensure that they execute in the proper order. Let's click on the Create Folder task, and I'll drag the arrow to Move CSV File, then I'll click on this one, and drag the arrow to the File System Task. Now, we'll create a folder, we'll copy a CSV File into it, and we'll update it to be read-only. Now, let's go…

Contents