DTS Package

[accessman2]

Hi,

I create DTS Package, when I do the Transform Data Task Properties, the Table/View (Source Tab), and Table Name (Destination Tab), how can I see the whole table name? Especially, Table Name in Destination Tab, it show [database name].[dbo].[table name], I only see the 1st char of the table name in the dropdown list. Could you please let me know how can I resize the dropdownlist in order to see the table name?

Thanks.

 

[ssmithri]

I do not believe that this is something that can be "adjusted." When you click on the drop-down, do you see the full table names?

 

[pdx_man]

You can't. Go to the Disconected Edit options for that task to enter in the table name explicitly.