Export Wizard

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Don Hans (anonymous_at_discussions.microsoft.com)
Date: 08/09/04 

Date: Mon, 9 Aug 2004 12:00:27 -0700

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?

Relevant Pages

  • RE: How to have either/or steps in a wizard
    ... Based on my understanding, your question is how to dynamically determine ... If I've misunderstood anything, ... the Wizard steps cannot be disabled by default. ... used to display data when the user selects Sql, ...
    (microsoft.public.dotnet.framework.aspnet.webcontrols)
  • RE: Multipage control
    ... Based on my understanding, you just want to create a wizard with ... I think TabControl with TabPage ... Have you tried this control? ... If you need some sample about creating wizard with TabControl, ...
    (microsoft.public.dotnet.framework.windowsforms.controls)
  • Re: creating wizard in .NET? ??
    ... Hi fgh, ... I would like to confirm my understanding of your issue. ... there are many third party wizard controls. ...
    (microsoft.public.dotnet.general)
  • Re: MS Access and VB.NET
    ... Thank you especially Herfried for not understanding what you were getting at ... > How does this help with importing text files into MS Access? ... > trying to do is code an action that duplicates the MS Access Import Wizard ...
    (microsoft.public.dotnet.languages.vb)
  • Re: DTS Changing data type from numeric to decimal
    ... you create a package and open it after the wizard. ... If I understand your fix, we can create the tables on the cluster were transfering too, then the DTS will apply the transfered data without defaulting to decimal. ... Did the Wizard create> the tables on the destination, I assume it must have done hence the problem. ... >> to transfer the database to a cluster that is case insenseitive. ...
    (microsoft.public.sqlserver.dts)