Issue

Anyone know this answer?
[New].[Configuration:]
O/S: Windows XP Service Pack2 on a machine named MERCURY
SQL Server Developer's Edition SP4
[Old].[Configuration]
O/S: Windows 2000 on a machine called PIONEER
SQL Server Developer's Edition SP4
[Problem].[ Description:]
1. Created 25 clean, functional DTS packages on PIONEER. On that machine,
any task in DTS designer which allows the user to select a single table name
from a drop-down list (Combo Box) (such as Bulk Insert Tasks), have Square
Delimited Indentifiers. For example:
[DBO].[TABLENAME1]
[DBO].[TABLENAME1]
[DBO].[TABLENAME1]
[DBO].[TABLENAME1]
2. Packages were then moved to a new computer, running the configuration
shown at the top.On that computer, the ODBC Administrator has default
settings for each new connection. These settings include the check box for
ANSI Quoted Identifiers which are ON (Checked). That is the same default as
Windows 2000 ODBC. We unchecked the box for every new connection.
3. When the packages from the PIONEER machine with square bracketed
identifiers in the Drop down lists were opened then square brackets
disappeared from the first display item as soon as you click the button of
the drop-down list. The drop down functionality apparently dropped the list
items from the old package, required the database with the same name on
PIONEER, repopulated the list, but this time, EVERY SINGLE IDENTIFIER WAS
DELIMITED WITH DOUBLE-QUOTES, and, worst of all, the correct name was
replaced with the first alphabetical name.The new list looked like this:
"DBO"."TABLENAME1"
"DBO"."TABLENAME1"
"DBO"."TABLENAME1"
"DBO"."TABLENAME1"
Doesn't that JUST BLOW!
Also, it appears that no connections can recognize the objects anymore.
Robert

> Anyone know this answer?
> [New].[Configuration:]
> O/S: Windows XP Service Pack2 on a machine named MERCURY
> SQL Server Developer's Edition SP4
> [Old].[Configuration]
> O/S: Windows 2000 on a machine called PIONEER
> SQL Server Developer's Edition SP4
> [Problem].[ Description:]
> 1. Created 25 clean, functional DTS packages on PIONEER. On that machine,
> any task in DTS designer which allows the user to select a single table
> name from a drop-down list (Combo Box) (such as Bulk Insert Tasks), have
> Square Delimited Indentifiers. For example:
> [DBO].[TABLENAME1]
> [DBO].[TABLENAME1]
> [DBO].[TABLENAME1]
> [DBO].[TABLENAME1]
> 2. Packages were then moved to a new computer, running the configuration
> shown at the top.On that computer, the ODBC Administrator has default
> settings for each new connection. These settings include the check box for
> ANSI Quoted Identifiers which are ON (Checked). That is the same default
> as Windows 2000 ODBC. We unchecked the box for every new connection.
> 3. When the packages from the PIONEER machine with square bracketed
> identifiers in the Drop down lists were opened then square brackets
> disappeared from the first display item as soon as you click the button of
> the drop-down list. The drop down functionality apparently dropped the
> list items from the old package, required the database with the same name
> on PIONEER, repopulated the list, but this time, EVERY SINGLE IDENTIFIER
> WAS DELIMITED WITH DOUBLE-QUOTES, and, worst of all, the correct name was
> replaced with the first alphabetical name.
>
>
>