Post reply

Import Flat File Database (Entire) to SQL Server?

  • 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?

  • 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
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply