RE: ODBC Imports of entire Database

I am using SSIS but it does not allow me to choose by tables. The only
option I can bring up is to create a query to bring in the information.
I need to be able to pull all of the tables from the ODBC source and update
them at will or scheduled updates.

"Vincent Xu [MSFT]" wrote:

Hi ,

My understanding of your issue is: You want to use dts to copy data from
another SQL database to current Sql 2005.

As you know, in SQL 2005, we have SSIS. You can use Import and Export
Wizard to achieve your purpose.

How to: Start the SQL Server Import and Export Wizard
http://msdn2.microsoft.com/en-us/library/ms140052.aspx

Hope this helps.


Best regards,

Vincent Xu
Microsoft Online Partner Support

======================================================
Get Secure! - www.microsoft.com/security
======================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================
This posting is provided "AS IS" with no warranties,and confers no rights.
======================================================



--------------------
Thread-Topic: ODBC Imports of entire Database
thread-index: AcbshvXCiFpH9R1BRJqN2xT9tTcfTw==
X-WBNR-Posting-Host: 66.191.71.66
From: =?Utf-8?B?RG9u?= <djw@xxxxxxxxxxxxxxxx>
Subject: ODBC Imports of entire Database
Date: Tue, 10 Oct 2006 09:13:01 -0700
Lines: 12
Message-ID: <BAAEC242-980B-4F8B-B093-427D784D10D0@xxxxxxxxxxxxx>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
Newsgroups: microsoft.public.sqlserver.dts
Path: TK2MSFTNGXA01.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.dts:68380
NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
X-Tomcat-NG: microsoft.public.sqlserver.dts

I would like to find a way of automating a Database copy and update from
an
existing server. I am only able to connect via ODBC to old server to
read
and cannot modify anything on the old server.
Is there a way with SSIS to copy that database?
I have as yet been unable to use SQL Management to view a list of tables
even, but with MS Query (in office) I have been able to list all of the
tables. I would like to pull all of this data into SQL2005 in order to
do
some analysis on it but just don't seem to see any answer other than
setting
up a package for each and every table. Any help would be GREATLY
appreciated
as I am still new to the SQL Admin world.

Don



.

Relevant Pages

  • Re: DBMS and lisp, etc.
    ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database. ... (eq (order-customer orderA) ...
    (comp.lang.lisp)
  • Re: complex filter and calculations in access
    ... switch to SQL view. ... query by switching to datasheet view, ... of your database using the from address in this post. ... pre-op infections yes/no ...
    (microsoft.public.access.queries)
  • Re: A little more meat this week
    ... implementation with a query processor capable of returning a result set ... then we can call it a result bag (SQL ... I'm looking at the data model and not database tools at this ... for a s/w developer and a s/w developer simplifies for the end user). ...
    (comp.databases.pick)
  • Re: complex filter and calculations in access
    ... when using a subquery on the same table as the main query, ... switch to SQL view. ... of your database using the from address in this post. ...
    (microsoft.public.access.queries)
  • Re: A little more meat this week
    ... said data includes lists." ... implementation with a query processor capable of returning a result set ... then we can call it a result bag (SQL ... I'm looking at the data model and not database tools at this ...
    (comp.databases.pick)