Import Data problems

I've setup a new Win2003 server with SQL 2000 server. I'm trying to import
all of the databases, backup jobs, etc.. from another server running Windows
2000 server. When I use the Import Data feature to bring over a database I
get binding errors. Is there an easier way to bring over all of the databases
and settings from SQL2k?
These might help:
http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://www.databasejournal.com/featu...le.php/3379901 Moving
system DB's
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.sqlservercentral.com/colu...rdatabases.asp
Moving Users
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scri...p?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
Andrew J. Kelly SQL MVP
"Cwhitmore" <Cwhitmore@.discussions.microsoft.com> wrote in message
news:C35F6CF3-4EFC-4CDB-8A9A-483132C8376E@.microsoft.com...
> I've setup a new Win2003 server with SQL 2000 server. I'm trying to import
> all of the databases, backup jobs, etc.. from another server running
> Windows
> 2000 server. When I use the Import Data feature to bring over a database I
> get binding errors. Is there an easier way to bring over all of the
> databases
> and settings from SQL2k?
>
>

Import Data problems

I've setup a new Win2003 server with SQL 2000 server. I'm trying to import
all of the databases, backup jobs, etc.. from another server running Windows
2000 server. When I use the Import Data feature to bring over a database I
get binding errors. Is there an easier way to bring over all of the database
s
and settings from SQL2k?These might help:
http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://www.databasejournal.com/feat...cle.php/3379901 Moving
system DB's
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.sqlservercentral.com/col...se
s.asp
Moving Users
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scr...sp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
Andrew J. Kelly SQL MVP
"Cwhitmore" <Cwhitmore@.discussions.microsoft.com> wrote in message
news:C35F6CF3-4EFC-4CDB-8A9A-483132C8376E@.microsoft.com...
> I've setup a new Win2003 server with SQL 2000 server. I'm trying to import
> all of the databases, backup jobs, etc.. from another server running
> Windows
> 2000 server. When I use the Import Data feature to bring over a database I
> get binding errors. Is there an easier way to bring over all of the
> databases
> and settings from SQL2k?
>
>

Import Data problems

I've setup a new Win2003 server with SQL 2000 server. I'm trying to import
all of the databases, backup jobs, etc.. from another server running Windows
2000 server. When I use the Import Data feature to bring over a database I
get binding errors. Is there an easier way to bring over all of the databases
and settings from SQL2k?These might help:
http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://www.databasejournal.com/features/mssql/article.php/3379901 Moving
system DB's
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.sqlservercentral.com/columnists/cBunch/movingyouruserswiththeirdatabases.asp
Moving Users
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
--
Andrew J. Kelly SQL MVP
"Cwhitmore" <Cwhitmore@.discussions.microsoft.com> wrote in message
news:C35F6CF3-4EFC-4CDB-8A9A-483132C8376E@.microsoft.com...
> I've setup a new Win2003 server with SQL 2000 server. I'm trying to import
> all of the databases, backup jobs, etc.. from another server running
> Windows
> 2000 server. When I use the Import Data feature to bring over a database I
> get binding errors. Is there an easier way to bring over all of the
> databases
> and settings from SQL2k?
>
>

Import Data from Oracle9i DB

I hope this is the correct forum to be posting this in but,

we have a database setup on a linux box that we are trying to get rid of and replace w/ sql server 2005 once we have the data off that machine. The problem that we are running into when we try and import data from that machine is, we get the following message during the DTS import / export wizard:

'Error Source: Microsoft OLE DB Provider for ODBC Drivers'
'Error Description: [Oracle][ODBC][Ora]ORA-00942: table or view does not exist'
'Context: Error calling OpenRowset on the provider'

Hopefully this is just a silly mistake on my end but I have been searching around and have not been finding anything too helpful.

does anyone have any advice?

thank you very much in advanceMoving to the SQL Server Integration Services forum.|||

Please note that ODBC via OleDB is not supported. To use any ODBC driver in SSIS, ADO.NET-ODBC bridge should be used.

One exception to this is the Execute SQL Task in the control flow, which has native ODBC support. Apart from that, to use ODBC directly, the option of using the extensibility model, either with a script component or custom component is available as well.