import database errors

  • I created a new database on a dev server and imported the production database to it. 

    There were three errors during that process.  Where are those errors logged.  The errors were complaining about a column name, but I don't know what is indicating that there is a problem ? 

    Thanks

  • Did you import using the DTS import/Export wizard? If so then you should be able to double click on the DTS package step name. I know that whole bunch of files are also created in the sql install directory, in my case, C:\Program Files\Microsoft SQL Server\80\Tools

     

  • Yes I used the DTS Import/Export Wizard in SQL2K.  I had it run immediately without saving the package.

    Didn't see any new files under Tools.

    Nothing in server log files either.

  • You don't get error logging when using the wizard.  Try Running the wizard again, but this time save the package.  Open the package in DTS Designer and enable package logging by opening Package Properties and designating an error file on the Logging tab.  You can also designate an exception file for a Transform Data Task by opening it's properties and clicking on the Options tab.

    Then, run the package and check your error and exception files.

    Greg

    Greg

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply