Post reply

DTS import wizard : Chose a destination : database

  • September 7, 2004 at 2:21 pm

    #59975

    Hi,

    SQL 2000 SP3

    With DTS Import Wizard, when I specifiy the name of a new destination database <new>,  I receive this error message:

    Error Source: Microsoft OLE DB Provider for SQL Server

    Error Description: CREATE DATABASE failed. Some file names listed could not be created. Check previous errors. Device activation error. The physical file name M:\mssql\data\new_db_name.mdf may be incorrect.

    I would like to change the path that DTS Import wizard choses. Instead of M:\mssql\data\ I would like to use C:\mssql\data by default.

    How can I change this ?

    Thank you

    Danny 

  • September 7, 2004 at 4:52 pm

    #522033

    I think the wizard uses the path that the Model database uses for it's files.  You're probably better off creating the database before using the DTS wizard so you can put the files where you want them.

    Greg

    Greg

  • September 8, 2004 at 4:47 am

    #522087

    The DTS Import Wizard will try and create the database in the default directory.

    The only way you can locate it elsewhere is to do as Greg suggested and create the database before running the wizard.

    --------------------
    Colt 45 - the original point and click interface

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

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