Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2003
    Posts
    212

    Unanswered: Table import wizard error

    I get the following error when i use DTS Table Import task.

    Createfile error on 'Servername.DBname.LOG'. Access is denied.

    Please help

  2. #2
    Join Date
    Feb 2004
    Posts
    492
    Do you have the proper permissions to create the table? Does the table already exist and if so, do you have permissions to drop the table and did you specify? Is the table in use by another proces?

  3. #3
    Join Date
    Sep 2003
    Posts
    212
    the user has db_owner role at the destination server and select privilege at the source server.

  4. #4
    Join Date
    Feb 2004
    Posts
    492
    Is the DTS Table Import task part of a package, if so, which user is configured to execute the package?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •