Import Flat File Database (Entire) to SQL Server?

• Vertigo44

  SSCarpal Tunnel

  Points: 4055

  More actions

  March 14, 2013 at 7:13 am

  #291058

  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?

• Phil Parkin

  SSC Guru

  Points: 246991

  More actions

  March 14, 2013 at 7:58 am

  #1597010

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

  The Import Wizard may help speed development of your import.

  The absence of evidence is not evidence of absence.
  Martin Rees

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel