Lab 6B Student Answer Sheet complete solutions correct answers key

Lab 6B Student Answer Sheet complete solutions correct answers key

DeVry University

Student Lab Activity

BIS 445 Business Intelligence and Data Analysis with Lab

Student Name:                                                                                                      

Using Lab 6B provide copies of your results from BIDS        

Part A:  Define a BIDS Integration Services project and ETL package

a.    Print Screen your BIDS Integration Services project  and ETL package that mimics Step 2.c and paste below.

Part B:  Define a View and a flat file

a.    Print Screen your window that mimics Step 2.h and paste below.

b.    Print Screen your window that mimics Step 2.k and paste below.

Part C:  Add and Configure a Flat File Connection Manager

a.    Print Screen your window that mimics Step 2.eand paste below.

b.    Print Screen your window that mimics Step 2.g and paste below.

c.    Print Screen your window that mimics Step 2.h and paste below.

d.    Print Screen your window that mimics Step 2.i and paste below.

Part D: Add and Configure an OLE DB Connection Manager

a.    Print Screen your window that mimics Step 2.c and paste below.

b.    Print Screen your window that mimics Step 2.d and paste below.

Part E:  Add a data flow task to the package

a.    Print Screen your window that mimics Step 2.c and paste below.

Part F: Add and configure the Flat File source

a.    Print Screen your window that mimics Step 2.e and paste below.

b.    Print Screen your window that mimics Step 2.f and paste below.

Part G: Add and configure the OLE DB destination

a.    Print Screen your window that mimics Step 2.f and paste below.

Part H: Tidy up the package

a.    Print Screen your window that mimics Step 2.b and paste below.

Part I: Test the package

a.    Print Screen your window that mimics Step 2.c and paste below.