"Jan" <anonymous@discussions.microsoft.com> wrote in message
news:0bd001c3b4da$323cc720$7d02280a@phx.gbl...
> Hi,
>
> I have a database with a dot (actually 2 dots) in its name,
> lets call it [foo.bar]. Selecting this database as source
> or destination in the DTS Import/Export Wizard gives me an
> error-message when I select "copy tables and views":
>
> Server 'foo' could not be found in sysservers.
>
> Selecting this database as destination seems to work
> anyway, but when selecting it as source, the wizard doesnt
> show any tables to copy.
>
> Is there a fix or workaround apart from renaming the database?
>
> Thanks,
> Jan
>

> I'm afraid that looks fairly terminal. I tried it manually building the
> package and you get similar errors. I think this is just a UI issue caused
> by the UI validation of objects, which means if you where to build the
> package in code I reckon it would work. That is whole lot more work of
> course so may not be acceptable.
>
> Sorry.
>
>
> --
> Darren Green
> http://www.sqldts.com
>
> "Jan" <anonymous@discussions.microsoft.com> wrote in message
> news:0bd001c3b4da$323cc720$7d02280a@phx.gbl...
> > Hi,
> >
> > I have a database with a dot (actually 2 dots) in its name,
> > lets call it [foo.bar]. Selecting this database as source
> > or destination in the DTS Import/Export Wizard gives me an
> > error-message when I select "copy tables and views":
> >
> > Server 'foo' could not be found in sysservers.
> >
> > Selecting this database as destination seems to work
> > anyway, but when selecting it as source, the wizard doesnt
> > show any tables to copy.
> >
> > Is there a fix or workaround apart from renaming the database?
> >
> > Thanks,
> > Jan
> >
>
>

>I tried also with no joy.
>
>I tried using Disco Edit to wrap the Catalog in [] and "" but alas nothing I
>did seemed to work.
>

> In article <eQfqVwRtDHA.1876@TK2MSFTNGP09.phx.gbl>, Allan Mitchell
> <allan@no-spam.sqldts.com> writes
> >I tried also with no joy.
> >
> >I tried using Disco Edit to wrap the Catalog in [] and "" but alas
nothing I
> >did seemed to work.
> >
>
> That's what I did too. Since we know the DataPump xxxObjectName uses the
> [] DB name format quite happily I reckon it must be something *like* DMO
> that is client-side only which causes the problems. I may be wrong and a
> profiler trace should reveal more of what really goes on.
>
> --
> Darren Green (SQL Server MVP)
> DTS - http://www.sqldts.com
>
> PASS - the definitive, global community for SQL Server professionals
> http://www.sqlpass.org
>