Post reply

Table Name dropdown list on Destination tab of Transform Data Task Properties screen

  • November 5, 2004 at 2:01 am

    #60485

    How do you increase the size of the above dropdown list?

    I have a fairly long database name, therefore that plus dbo plus table name is too long to be visible in this list (it is cut off at 25 characters). I can therefore not make out the table names.

    This makes using this tool cumbersome, as it involves a lot of guess work.

    Using SQL 2000 sp 3a on Windows XP

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 5, 2004 at 5:54 am

    #529074

    Where I've had this before I've selected the SQL Query option and then Build Query.  This gives you a list box that can be re-sized and you can do the select statement via the query.

     

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply