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.
Read more →
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): T-SQL Stored Proc experience Windowed Function experience Basic Join understanding Row Number Generation There are a number of ways to generate row numbers in T-SQL.
Read more →
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.
Read more →
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): Error Logging experience UDF (User Defined Function) creation experience Creating a template Package that handles errors.
Read more →
I apologize for the long pause in posting. I have been extremely busy with my Masters program. I took my finals on Monday for this semester, so I finally have some free time!
Read more →
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.
Read more →
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.
Read more →
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.
Read more →
I have always viewed "social" movements on the Internet with somewhat of a mocking look. Think of a cross between Spock's eyebrow raise and the gleeful mocking smile and laugh that you crack when you see someone run a red light right into the waiting arms of the cop on the other side of the intersection.
Read more →
I started a Blog a few weeks ago to share my knowledge of SSIS with people. I didn't think it would really get anyone's attention, I just felt like I needed to get information out there because so many people do horrible things with this technology!
Read more →