How to perform a Read File transformation (Enterprise Manager)

How to perform a Read File transformation (Enterprise Manager)

To perform a Read File transformation

1. On the Transformations tab of the Transform Data Task Properties or Data Driven Query Task Properties dialog box, click the Source column containing the file specification information, and then click the Destination column to which you want the contents of the file copied.
   
   
2. Do one of the following:
   • If there is a mapping arrow connecting the two columns, click Delete, and then click New.
     
     
   • If there is no mapping arrow, click New.
3. In the Create New Transformation dialog box, click Read File.
   
   
4. Click the General tab, and then click Properties.
   
   
5. In the Read File Transformation dialog box, do the following:
   • In the Directory box, type the name of the directory from which the files are to be read.
     
     
   • In the File type list, click the file type you want.
     
     
   • Select the Error if file not found check box to fail the step when no file matches the source column. Clear this check box to null the destination column.

See Also

Read File Transformation

Transform Data Task