Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
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: Thursday, October 16, 2014 11:16 AM
Points: 219, Visits: 724
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


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 7:20 AM
Points: 5,180, Visits: 12,033
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.
Post #1430981
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse