"Vincent Xu [MSFT]" wrote:

> Hello,
>
> -- Get the list of tables and import all of them creating tables in SQL if
> needed.
>
> When you run Import and Export Wizard, it will enable you to import the
> entire database from source server. I have tested on my machine. Check the
> article:
>
> How to: Start the SQL Server Import and Export Wizard
> http://msdn2.microsoft.com/en-us/library/ms140052.aspx
>
> Creating Packages Using the SQL Server Import and Export Wizard
> http://msdn2.microsoft.com/en-us/library/ms141209.aspx
>
> -- I also need to be able to update the tables daily preferrably using an
> SSIS package so that we can maintain the SQL base and not have to recreate
> it at each use.
>
> When you created a package, you can schedule it to run any time you want.
>
> How to: Run a Package Using a SQL Server Agent Job
> http://msdn2.microsoft.com/en-us/library/ms139805.aspx
>
> 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: AcbtPPxmdjicoknEQSuo0y0suKO2wg==
> >>X-WBNR-Posting-Host: 66.191.71.66
> >>From: =?Utf-8?B?RG9u?= <djw@nospam.postalias>
> >>References: <BAAEC242-980B-4F8B-B093-427D784D10D0@microsoft.com>
> <nOK2XaN7GHA.1860@TK2MSFTNGXA01.phx.gbl>
> >>Subject: RE: ODBC Imports of entire Database
> >>Date: Wed, 11 Oct 2006 06:56:01 -0700
> >>Lines: 88
> >>Message-ID: <D13168BF-FAE6-4067-B2B1-225D7BCB0B81@microsoft.com>
> >>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:68394
> >>NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
> >>X-Tomcat-NG: microsoft.public.sqlserver.dts
> >>
> >>Using SSIS it does not give me the option of importing the entire
> database.
> >>It gives me a chance to script only and I do not know just how to get the
> >>entire database listed and create the appropriate tables based on the
> input.
> >>Hopefully I am more clear this time.
> >>What I need to do using SSIS is:
> >> Get the list of tables and import all of them creating tables in SQL if
> >>needed.
> >> I also need to be able to update the tables daily preferrably using an
> SSIS
> >>package so that we can maintain the SQL base and not have to recreate it
> at
> >>each use.
> >>
> >>"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@nospam.postalias>
> >>> >>Subject: ODBC Imports of entire Database
> >>> >>Date: Tue, 10 Oct 2006 09:13:01 -0700
> >>> >>Lines: 12
> >>> >>Message-ID: <BAAEC242-980B-4F8B-B093-427D784D10D0@microsoft.com>
> >>> >>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
> >>> >>
> >>>
> >>>
> >>
>