Posted by Erland Sommarskog on 11/27/07 22:59

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 Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: ORDER BY AND GROUP BY CLAUSE
• Prev in forum: Re: ORDER BY AND GROUP BY CLAUSE
• Thread view: Re: Importing data into SQL Server 2005 via ODBC

[Reply to this message]