Using Data Transformation Services, part 6: Intro to Text Transfer with Filtering

In this tutorial, Jay describes the transformation of data from one comma delimited text file to another. Sometimes applications require transfering information from one text file to another, making a subset of the original with certain constraints. The subset is based on a query of the original text, but there is no built-in support for querying text file connections. It is possible to make this transfer by using an intermediate step, which this article focuses on.


Read the full article here: Using Data Transformation Services, part 6: Intro to Text Transfer with Filtering

For more discussion go here: Blog Article Discussion