SQL Server Integration Services (SSIS) allows you to import and export data from SQL Server databases using an easy-to-navigate graphical interface. It replaces the Data Transformation Services (DTS) found in earlier versions of SQL Server.
Time Required: 20 minutes
- Open Microsoft SQL Server Management Studio (SSMS).
- Right-click on the name of the database into which you wish to import data.
- From the Tasks menu, choose Import Data.
- When the welcome screen appears, click Next to advance into the wizard.
- Click the Data Source drop-down list and choose the appropriate data source. If you are importing from a text file, choose Flat File Source. You may also choose to import data from Microsoft Access, Microsoft Excel, other relational databases (including SQL Server and Oracle) or a variety of other data sources.
- Use the Browse button to navigate to the file you wish to import. Click the Next button to continue.
- Review the import preview and confirm that you have correctly configured the import settings. Click the Next button to continue.
- From the Destination drop-down list, choose SQL Server Native Client.
- Use the Database drop-down list to select the destination database for your import operation. Click the Next button to continue.
- On the next screen, verify that the table and column mappings are correct and then click the Next button to continue.
- Click the Finish button on two screens and the import will begin.
What You Need
- Microsoft SQL Server 2005 or later
- Flat file to import