Using Data Transformation Services, part 4: Using the DTS Designer Objects (continued-2) - Data Transfer Source
(Page 3 of 10 )
Source
In the DTS editor drag and drop a source type text file connection, which will pop up a Connection properties window as shown.
Using the ellipsis browse to the file described earlier called, ClientInfo.txt. This is the file that will be used as the source whose content was shown in a previous picture. When you click OK to this window you will be required to look at the file properties before further proceeding as shown in this Text File Properties window,
since the first row shown in the preview area has the column names it will be necessary to check the 'First row has column names' check box. Clicking on Next will take you to the next window as shown in this picture. Since the original data was comma separated text this window automatically picked up this information. If needed this may be changed to a different separator type.
You click Finish and then OK to the ensuing window that will complete the configuring of the Text file connection. In the DTS editor you will be seeing the icon for the Text file object.
Next: Data Transfer Destination >>
More MS SQL Server Articles
More By Jayaram Krishnaswamy
