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.

The File System tasks

The File System tasks - SQL Server Tutorial

From the course: SQL Server Integration Services

Start my 1-month free trial

The File System tasks

“

- [Instructor] Data preparation tasks are used to copy files from a variety of locations. These include the Hadoop File System Task for copying files within a Hadoop cluster, the FTP Task for downloading or uploading files to an FTP server, and the File System Task for working with files and folders on your local or network disk drives. They all generally require the same sorts of configuration. You need to specify a source location, a destination location, and any login details required to access the files. Let's take a look at the File System Task as an example of the activities that you can do with these. First, let's create a new package in our solution. I'm going to close the Data Flow Design. And then I'll come over here to the Solution Explorer, right-click on Packages, then choose New SSIS Package. Then I'll right-click on the new one, this one here called Package1, and I'll choose Rename. And I'll call it FileSystemExample. When you press enter, you'll get this warning…

Contents