Module 8 Importing and Exporting Data. Module Overview. Transferring Data To/From SQL Server Importing & Exporting Table Data Inserting Data in Bulk. Lesson 1: Transferring Data To/From SQL Server. Overview of Data Transfer Available Tools for Data Transfer
Importing and Exporting Data
Extract Transform Load
Bulk Copy Program (bcp)
Import / Export Wizard
XML Bulk Load
In this demonstration you will see how to use SQL Server Integration Services to export data from a table to a flat file
Easy to use wizard for creating an SSIS package that performs simple data transfers
In this demonstration you will see how to use the Import/Export Wizard to export data to a CSV file
Creating a format file:
bcpAdv.Sales.Currencyformatnul -T -c –x -f Cur.xml
Exportingdatainto a file:
bcpAdv.Sales.Currency out Cur.dat -T –c
Importing data using a format file:
bcptempdb.Sales.Currency2 in Cur.dat -T -f Cur.xml
FIRSTROW= 2)AS a;
Estimated time: 45minutes
Proseware regularly receives updates of currencies and exchange rates from an external provider. One of these files is provided as an Excel spreadsheet, the other file is provided as a comma-delimited text file. You need to import both these files into tables that will be used by the Direct Marketing team within Proseware.
Periodically the Marketing team requires a list of prospects that have not been contacted within the last month. You need to create and test a package that will extract this information to a file for them.
You are concerned about the import performance for the exchange rate file and you are considering disabling constraints and indexes on the exchange rate table during the import process. If you have time, you will test the difference in import performance.