How to perform a Middle of String transformation (Enterprise Manager)

How to Install SQL Server 2000

How To

How to perform a Middle of String transformation (Enterprise Manager)

To perform a Middle of String 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 string to be modified, and then click the Destination column where you want the modified string to be placed.

  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, select Middle of String.

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

  5. In the Start position (1 based) box, type or select the first character position occupied by the substring.

  6. Optionally, if you want to remove characters from the end of the source string, select the Limit number of characters to check box and enter a maximum substring length.

See Also

Middle of String Transformation

Transform Data Task