posts - 10, comments - 49, trackbacks - 0

SSIS Madness

Using System Variables as Parameters in an OLE DB Source Query

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...

posted @ Wednesday, August 20, 2008 9:31 AM | Feedback (10) | Filed Under [ SSIS Madness ]

SSIS Performance Framework Part 3

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...

posted @ Thursday, May 01, 2008 7:54 AM | Feedback (2) | Filed Under [ SSIS Madness ]

Row Numbers in a DataFlow

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...

posted @ Wednesday, February 13, 2008 10:31 AM | Feedback (11) | Filed Under [ SSIS Madness ]

SSIS Performance Framework Part 2

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...

posted @ Monday, February 11, 2008 4:24 PM | Feedback (4) | Filed Under [ SSIS Madness ]

SSIS Performance Framework Part 1

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...

posted @ Monday, February 11, 2008 10:34 AM | Feedback (3) | Filed Under [ SSIS Madness ]

Powered by:
Powered By Subtext Powered By ASP.NET