Microsoft Office Tutorials and References
In Depth Information
4.
Use Windows Authentication/SQL Server Authentication.
5.
Choose the source database. In this case, select the “AdventureWorks” database.
6.
Next, choose the destination options and, in this case, select “Flat File Destination.”
7.
Choose the destination file name, and set the format to “Delimited.”
8.
Choose “Copy data from one or more tables or views” from the “Specify Table Copy or
Query” window.
9.
From the Flat File Destination window, click “Edit mappings,” leave the defaults “Create
destination file,” and click OK.
10.
Click Finish, and then click Finish again to complete the wizard.
11.
Once execution is complete, you’ll see a summary displayed. Click Close. This step would
create the .dtsx file, and you need to finally run the package once to get the output file.
Importing can also be done by using various data flow sources and writing custom event handlers. Let’s do it step
by step in the next Problem Case.
prOBLeM CaSe
the sales data from the adventureWorks database consists of more than seven tables, but for simplicity let’s
consider the seven tables displayed in Figure 1-17 . You need to retrieve the information from these seven tables,
extract the data, clean some of the data or drop the columns that aren’t required, and then load the desired data
into another data source—a flat file or database table. You might also want to extract data from two different data
sources and merge it into one.
 
Search JabSto ::




Custom Search