Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Location
    New York, NY
    Posts
    136

    Question Unanswered: DTS Data Transform task: how to hide DB and schema names?

    Hi All,

    I'm stuck up with a strange problem.
    When i try to setup a Transform Data task in DTS, the table drop down shows fully qualified table name.

    i.e. <database name>.<schema name>.<table name>

    as you can see in the attached screenshot. With this I cant see the full table name and am not able to make the correct selection.

    Where can i change the properties so that it displays only the table name?

    Thanks
    Rohit
    Attached Thumbnails Attached Thumbnails transform data.JPG  

  2. #2
    Join Date
    Sep 2003
    Location
    New York, NY
    Posts
    136
    never mind, started using SSIS

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •