SSIS Madness
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...
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
That you have read and understood/implemented parts 1 and 2
Performance Tuning for SSIS Packages.
Preparation
This is the 3rd and final part to this series. In this part, I will cover techniques and settings in your SSIS packages to tune them so that they perform at appropriate speeds. To really test speed, I need lots of data to test...
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):
Basic SSIS usage
Basic VB.Net usage
Row Numbers in a DataFlow.
I try to post often in the Forums here at SQLTeam.com for a few reasons. First, I get to help people in an interactive way which is very rewarding to me. Second, I get to learn from others who post answers. I appreciate the forums very much and the few tricks I...
You can expect:
This is a medium intensity post (you should not get a migraine, but I make no promises).
I Expect (that you have the following experience):
Excel experience
Complex SQL queries
Performance Reporting for SSIS Packages.
Part 1 helped us set up the logging for SSIS so that we could retrieve the data we need to make the pretty charts that help us in tuning our packages. This information is VITAL for engaging in REAL performance tuning. You need PROOF and not anecdotes about how X is faster...
You can expect:
This is a medium intensity post (you should not get a migraine, but I make no promises)
I Expect (that you have the following experience):
The ability to POINT and CLICK on your OWN (I won't hold your hand like a little girl. Get over it.)
at lease SOME SSIS experience
SSIS Logging
Stored Procedure writing
Performance Measuring in SSIS
SSIS Logging lets you see what the heck is going on during run-time of your packages. You can see where failures occur and that is what...