Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004
    Posts
    57

    Unanswered: SSIS Import tables only 'sees' the system databases in the import wizard.

    New to 2005. Restored a db from 2000. No problems. Want to copy tables from it to a new db on the same box (also in 2005). Go into the import / export wizard. There is a drop down labeled 'database' in the second step. All it shows are system databases (master, model, msdb,...) but not the ones I created or restored. Windows authentication. I could see those databases in 2000 no problem. What am i missing?

    Thanks Ray

  2. #2
    Join Date
    Jun 2004
    Posts
    57
    More detail about my question: Does each db in sql server have a permission that needs to be appropriately set so a windows authenticated user can see it?

    Ray

Posting Permissions

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