How to perform a Write File transformation (Enterprise Manager)

How to Install SQL Server 2000

How To

How to perform a Write File transformation (Enterprise Manager)

To perform a Write 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 name column and the Source column containing the data column.

  2. Click New, and in the Create New Transformation dialog box, click Write File.

  3. Click the General tab, and then click Properties.

  4. In the Write File Transformation Properties dialog box, do the following:
    • In the Directory box, type the name of the directory in which the files are to be saved.

    • In the File type list, click the file type you want.

    • In the File name column list, click the column that contains the file names.

    • Under Handle existing file, click the option that you want.

See Also

Write File Transformation

Transform Data Task