Import Flat File Database (Entire) to SQL Server?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » Import Flat File Database (Entire) to SQL...

Import Flat File Database (Entire) to SQL Server?

Rate Topic

Display Mode

Topic Options

Author

Message

Vertigo44

Posted Thursday, March 14, 2013 7:13 AM

SSC Veteran

Group: General Forum Members
Last Login: Wednesday, April 17, 2013 10:44 AM
Points: 209, Visits: 655

We were given an ODBC driver to connect to some flat file database. This database is no longer in use but we want to keep the data around for auditing purposes. The users would like to convert the flat file database into a SQL Server database. Would I have to use SSIS and do this table by table? Or can I import the entire thing at once?

Post #1430949

Phil Parkin

Posted Thursday, March 14, 2013 7:58 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 9:19 AM
Points: 4,234, Visits: 9,469

Table by table. As long as SSIS can recongnise and use the driver OK.

The Import Wizard may help speed development of your import.

____________________________________________________________________________________________

Help us to help you. For better, quicker and more focused answers to your questions, consider following the advice in this link:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

If you are asking for help and your post does not contain a question, you should expect responses which do not contain any answers. Put a question mark in there somewhere - it's not rocket science.

Post #1430981

« Prev Topic | Next Topic »

Permissions