You can expect:
This is a low intensity post (you should be able to do this in your sleep).
I Expect (that you have the following experience):
Simple SSIS Dataflow work
OLE DB Source Queries with Parameters
The OLE DB Source allows you to enter a Select statement to retrieve data from a source. As I stated several times before, this is the preferred method. If you want to use parameters, this is the ONLY method you can use. It is fairly easy to use parameters. You just use a ? for each parameter you wish to map. Then you click...