Posted by Chloe C on 11/27/07 10:25

Hi

I've got an Ingres database of some 200 tables which I need to import
every night into SQL Server 2005 for use by Reporting Services. Most
of the tables will come across unchanged (a few need massaging to
handle time intervals correctly), but the Import Wizard only seems to
want to import one table (or more accurately query) at a time. I seem
to remember the old 2000 Import Wizard handled multiple tables - is
there any way of processing multiple tables in 2005, or must I resign
myself to writing 200 import packages in SSIS.

Chloe Crowder
The British Library

• Next in forum: Off Topic - Databindings and XML - Binding Text between XML Tags instead of XML Tag Atrribute Information
• Prev in forum: Re: FOREACH LOOP container and looping through record set ...
• Thread view: Importing data into SQL Server 2005 via ODBC

[Reply to this message]