I have a windows 2000 machine with sp2 running SQL server 7.0 sp3. I am trying to creat a DTS import package. I am using the wizard in which I specify SQL accounts to connect to the different servers that I am working with. The source server uses the account username to connect to the database (i.e dbname.username.table). The same username is used to connect to the destination database, but when the tables are selected it comes up as dbname.dbo.table. When you click on the drop down list, there are not any dbo options in it. The list has the actual owner which is the username (i.e. dbname.username.table).
Does anyone know how to change the default so that it will use the same name as the connection that was made to the database?
Change for dbname.dbo.table to dbname.username.table
I have about 1400 tables that I need to import and I don't want to change each one in the wizard individually.