Showing posts with label My Articles. Show all posts
Showing posts with label My Articles. Show all posts

Thursday, October 14, 2010

How to apply Conditional Split in a SSIS package without using Conditional Split transform

I'm reading: How to apply Conditional Split in a SSIS package without using Conditional Split transformTweet this !
Conditional Split is a very simple and effective transform, and is one of the most commonly used transforms in a SSIS package. But those who do not pay attention to detail or those who are do not work regularly / extensively in SSIS, often miss the detail that once a record matches a criteria, it's moved to the first matching output path. So each output path has exclusive records, and no repeated records.

Many times we come across a situation where we have records that are matching more than one criteria and we need such records in more than one output paths. Generally we take help of multicast transforms in such scenarios, but that is not an efficient design, and definitely such design won't scale. When the question / task comes of splitting data, right from the schools / parlance of SSIS, we are used to answer / use "Conditional Split" Transform. But we know the limitation of this transform for the scenario in question and design issues with Multicast transform. So what is the way to conditionally split data in an SSIS package without the help of this transform ?

Today one of my article got published and it's titled " Intelligent Conditional Split in an SSIS package "; it is aimed to present a solution at this issue, and the same can be read from here. The origins of this technique is derived from the niche art of custom SSIS components / transforms development methodology. If this solution is wrapped as a custom component, it can be used very well as an Intelligent Conditional Split component. To avoid ruining the value of my article, I would limit my explanation and would let you check out the original article. Feel free to share your opinion about this article.

Monday, May 24, 2010

List of my articles published on community websites till 24 May 2010

I'm reading: List of my articles published on community websites till 24 May 2010Tweet this !

I am not a very popular, big or well connected name in the industry, but I am trying to be at least a respected name :) I am well respected among my friends and colleagues at Capgemini for my work in my technical area, and now I am trying to put my knowledge to test and use for the entire technical community by the medium of my blog and other community websites. I am always up for sharing something new, that has not been published a million times on blogs, books and websites. Today my article on how to achieve spatial data support in ssis got published on sql-server-performance.com, and on this day I thought of summarizing a list of all the major articles that I have authored till date. Four of these articles also got featured on MSDN SSIS Community Buzz, and a few of them on multiple community websites. Below is the list is no specific order.

In case if you have read any of my articles, and have any feedback for me, please feel free to share it with me.

Monday, November 23, 2009

My first article on SQLServerCentral.com - Microsoft Business Intelligence Project Booster Kit

I'm reading: My first article on SQLServerCentral.com - Microsoft Business Intelligence Project Booster KitTweet this !
Today on 24-Nov0-2009, my first article has been published on SQLServerCentral.com. And I feel extremely happy and excited about this. Many a times I get confronted by an expectation that I need to push my team towards delivery through technical expertise, by empowering them with whatever they need and thus decreasing time to delivery which can result into increased revenues.

It's not always that one himself / herself needs to be a super expert. Knowledge is always power and there's no doubt in it, but when you work in a team, you can't expect each and every team member having same level of expertise and the same speed of execution of development. So remaining within the boundaries of costs, as a team lead one needs to educate as well as facilitate oneself and team with tools and stuff that can boost up the development process and reduce time in tackling known challenges.

Microsoft Business Intelligence Project Booster Kit is my first attempt to share my experiences about a basic set of tools and documents / documenting methods which I term as "Booster Kit" that can help any development team with stuff they can use in their day to day work to help them gear their project faster directly / indirectly in the shorter / longer term at one / another phase of the project life-cycle.

If you came across my blog through my article on SQLServerCentral.com, please feel free to drop your valuable feedback a comment on this post. Also feel free to reach out to me on siddhumehta_brain@yahoo.co.in.
Related Posts with Thumbnails