Posted by Chloe C on 11/28/07 10:28

On Tue, 27 Nov 2007 22:59:18 +0000 (UTC), Erland Sommarskog
<esquel@sommarskog.se> wrote:

>Chloe C (chloe@mcrowdd.plus.com) writes:
>> 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.
>
>Are you looking at the Import Wizard in Mgmt Studio? I think you should
>look into SQL Server Integration Services, for which you can create
>packages in Business Intelligence Development Studio. (Although that is
>as much I know about SSIS.)

Erland

I was rather hoping to, in effect, automate the creation of my SSIS
package with the Import Wizard, otherwise I need to do each import as
a separate task in SSIS.

Ah well, do it the hard way...

Chloe

[Back to original message]