File-Handling and Processing Methods
SSIS has many powerful capabilities for handling and processing files. They might be data files from which information needs to be extracted. They might be signal files that are used to coordinate a process between two systems. They might simply be regular document files that need some administrative management. SSIS has features that can be helpful in all of these scenarios.
This chapter examines common file-handling tasks, and how you can accomplish those tasks with SSIS. The common file-handling tasks addressed in this chapter include the following:
This chapter is structured into the following three sections related to the problem, design, and solution of ETL extraction processes using SSIS:
Many data-management tasks involve manipulating files. A file must be transferred from another ...