Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Import Flat File Database (Entire) to SQL Server? Expand / Collapse
Posted Thursday, March 14, 2013 7:13 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 7:23 AM
Points: 233, Visits: 810
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
Posted Thursday, March 14, 2013 7:58 AM



Group: General Forum Members
Last Login: Today @ 2:09 PM
Points: 7,969, Visits: 19,088
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.

When you ask a question (and please do ask a question: "My T-SQL does not work" just doesn't cut it), please provide enough information for us to understand its context.

If your posting includes some T-SQL code, please surround the code with IFCode formatting tags. It helps readability a lot.
Post #1430981
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse