Lab 6B Student Answer Sheet
Student Name:
Using Lab 6Bprovide 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.
