DTS Import - Invalid Object

[benvegiard]

Hi All...

I am writing a DTS package using the Import Data wizard to copy data from our Production server to our Test server (both SQL 2k(sp 3a) on W2k os).

About 95% of the database moves over fine. However, a handful of tables/views are reporting "[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'vwTxTotalHrsByEmpAP'" Other views not coming over are named very similar. All objects are owned by DBO.

Are the names too long? I haven't found any documentation regarding object name lengths. Anything else you can think of?

Thanks,
Ben

 

[Patrick2002]

Difficult to say from a distance. If you have any doubts about the naming, read the following :

Rules for Regular Identifiers
The rules for the format of regular identifiers are dependent on the database compatibility level, which can be set with sp_dbcmptlevel. For more information, see sp_dbcmptlevel. When the compatibility level is 80, the rules are:

The first character must be one of the following:
A letter as defined by the Unicode Standard 2.0. The Unicode definition of letters includes Latin characters from a through z and from A through Z, in addition to letter characters from other languages.


The underscore (_), "at" sign (@), or number sign (#).
Certain symbols at the beginning of an identifier have special meaning in SQL Server. An identifier beginning with the "at" sign denotes a local variable or parameter. An identifier beginning with a number sign denotes a temporary table or procedure. An identifier beginning with double number signs (##) denotes a global temporary object.

Some Transact-SQL functions have names that start with double at signs (@@). To avoid confusion with these functions, it is recommended that you do not use names that start with @@.

Subsequent characters can be:
Letters as defined in the Unicode Standard 2.0.


Decimal numbers from either Basic Latin or other national scripts.


The "at" sign, dollar sign ($), number sign, or underscore.
The identifier must not be a Transact-SQL reserved word. SQL Server reserves both the uppercase and lowercase versions of reserved words.


Embedded spaces or special characters are not allowed.
When used in Transact-SQL statements, identifiers that fail to comply with these rules must be delimited by double quotation marks or brackets.

Hope this helps any. Greetings from Pat ;-)