Not sure this is the place to ask, but my understanding
is that this wizard is based on DTS.

Using the export wizard to copy objects between
databases. The process end with errors:

'Cannot use empty object or column names. Use a space
if necessary.' and 'Incorrect syntax near ".'

I assume this means a problem with one of the objects it
is attempting to move, but which object? I believe it is
a view, from looking at what has been successfully
copied. I have also tried to copy objects one at a time
to narrow it down, but there are a lot of them and
dependencies make this process difficult

Is there any way to make the Export create a log, or give
more info so that I can find the problem?

You are correct the Export wizard uses DTS.

DTS will choke on empty columnnames as you are finding out so

SELECT SUM(col1) FROM TABLE

is no good to DTS

The incorrect sytax problem sounds like you may have an embedded . and DTS
has tried to interpret it incorrectly.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"Don Hans" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Thanks for the quick reply.

I'm still confused tho...how is SELECT SUM(col1) FROM
TABLE an empty column name? Also, I have checked the
views in Enteprise Manager, and the syntax checks out on
all of them.....

Anyway, if anyone has any ideas on how to find in what
object the problem is, I'd loave the help!

Thanks!

Go to Query Analyser and do this

CREATE TABLE T(C int)
GO
INSERT T(C) VALUES(1)
GO
SELECT SUM(C) FROM T

What is the column name ?

Syntactically there is nothing wrong

In a view you have to define column names for each column

CREATE VIEW V
AS
SELECT SUM(C) FROM T
GO

Server: Msg 4511, Level 16, State 1, Procedure V, Line 3
Create View or Function failed because no column name was specified for
column 1.


You are probably using the Copy Objects task and this writes out files to a
directory before it does anything containing your objects and data.




--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


<anonymous (AT) discussions (DOT) microsoft.com> wrote

When you use an aggregate function, you need to alias the column to
assign a namespace for the object. For example:

SELECT SUM(col1) as MyNewColumn
from Table

Hope this helps.

- Glen

anonymous (AT) discussions (DOT) microsoft.com wrote:

When you use an aggregate function, you need to alias the column to
assign a namespace for the object. For example:

SELECT SUM(col1) as MyNewColumn
from Table

Hope this helps.

- Glen

anonymous (AT) discussions (DOT) microsoft.com wrote:

When you use an aggregate function, you need to alias the column to
assign a namespace for the object. For example:

SELECT SUM(col1) as MyNewColumn
from Table

Hope this helps.

- Glen

anonymous (AT) discussions (DOT) microsoft.com wrote: