http://www.centralflsoftware.com/blog/ Innovation. Imagination. Delivered. en-us Christopher L Price Thu, 20 Nov 2008 13:45:27 GMT newtelligence dasBlog 2.3.9074.18820 blog@centralflsoftware.com blog@centralflsoftware.com http://www.centralflsoftware.com/blog/Trackback.aspx?guid=b43a4834-fb65-4e7a-8f89-648c10d93966 http://www.centralflsoftware.com/blog/pingback.aspx http://www.centralflsoftware.com/blog/PermaLink,guid,b43a4834-fb65-4e7a-8f89-648c10d93966.aspx Christopher Price 28.171599 -82.001953 http://www.centralflsoftware.com/blog/CommentView,guid,b43a4834-fb65-4e7a-8f89-648c10d93966.aspx http://www.centralflsoftware.com/blog/SyndicationService.asmx/GetEntryCommentsRss?guid=b43a4834-fb65-4e7a-8f89-648c10d93966 A link to my SSIS Business Rules Article:

http://geekswithblogs.net/ReelDeepDotNet/archive/2008/03/07/ssis-business-rules-engine.aspx http://www.centralflsoftware.com/blog/PermaLink,guid,b43a4834-fb65-4e7a-8f89-648c10d93966.aspx http://www.centralflsoftware.com/blog/2008/11/20/SSISBusinessRulesArticle.aspx Thu, 20 Nov 2008 13:45:27 GMT A link to my SSIS Business Rules Article:<br> <br> <a href="http://geekswithblogs.net/ReelDeepDotNet/archive/2008/03/07/ssis-business-rules-engine.aspx"> http://geekswithblogs.net/ReelDeepDotNet/archive/2008/03/07/ssis-business-rules-engine.aspx</a><img width="0" height="0" src="http://www.centralflsoftware.com/blog/aggbug.ashx?id=b43a4834-fb65-4e7a-8f89-648c10d93966" /> http://www.centralflsoftware.com/blog/CommentView,guid,b43a4834-fb65-4e7a-8f89-648c10d93966.aspx SSIS http://www.centralflsoftware.com/blog/Trackback.aspx?guid=6df0cdec-07bc-4b41-b74a-818e5589367d http://www.centralflsoftware.com/blog/pingback.aspx http://www.centralflsoftware.com/blog/PermaLink,guid,6df0cdec-07bc-4b41-b74a-818e5589367d.aspx Christopher Price 28.171599 -82.001953 http://www.centralflsoftware.com/blog/CommentView,guid,6df0cdec-07bc-4b41-b74a-818e5589367d.aspx http://www.centralflsoftware.com/blog/SyndicationService.asmx/GetEntryCommentsRss?guid=6df0cdec-07bc-4b41-b74a-818e5589367d I had an opportunity to attend my first Tampa SQL BI Meeting last night and I wanted to share some of my thoughts from the SSIS demo that was given.
The first thing that really caught my attention is complexity of expressions that are used in a conditional split. I started picturing the nightmare scenario of debugging it and figured there has to be a better way. Enter the Script Component. The script component allows you to define multiple outputs and by monkeying (yeah thats a technical term) with the ExclusionGroup property you can filter the input rows. I am probably biased towards this technique (since my background is primarily in software development) and will need to find the time to do some analysis to see if there is a performance difference between the two methods.
The second item that got my thinking during the demo is more of a difference in approach. The case that was being presented had a requirement that before the package did any work a rowcount on the source data had to occur. If the row count returned 0 no further processing occured otherwise the destination was truncated and reloaded. To accomplish this task the presenter used an 'Execute SQL Task' to run the count query and then used to a 'Script Task' to determine if the control flow should proceed.
My thought on accomplishing this 'requirement' is a little more condensed. I would use the 'Execute SQL Task' but instead of a 'Script Task', I would use a 'Precedence Constraint' to modify the flow if necessary. By writing a simple expression to determine if the variable assigned to in the 'Script Task' is greater than zero you could either continue with required work or direct to an error flow.
Thats pretty much all for today...


Tight Lines!!


--Chris http://www.centralflsoftware.com/blog/PermaLink,guid,6df0cdec-07bc-4b41-b74a-818e5589367d.aspx http://www.centralflsoftware.com/blog/2008/03/11/TampaSQLBIMeeting.aspx Tue, 11 Mar 2008 12:33:53 GMT I had an opportunity to attend my first Tampa SQL BI Meeting last night and I wanted to share some of my thoughts from the SSIS demo that was given. <br> The first thing that really caught my attention is complexity of expressions that are used in a conditional split. I started picturing the nightmare scenario of debugging it and figured there has to be a better way. Enter the Script Component. The script component allows you to define multiple outputs and by monkeying (yeah thats a technical term) with the ExclusionGroup property you can filter the input rows. I am probably biased towards this technique (since my background is primarily in software development) and will need to find the time to do some analysis to see if there is a performance difference between the two methods. <br> The second item that got my thinking during the demo is more of a difference in approach. The case that was being presented had a requirement that before the package did any work a rowcount on the source data had to occur. If the row count returned 0 no further processing occured otherwise the destination was truncated and reloaded. To accomplish this task the presenter used an 'Execute SQL Task' to run the count query and then used to a 'Script Task' to determine if the control flow should proceed. <br> My thought on accomplishing this 'requirement' is a little more condensed. I would use the 'Execute SQL Task' but instead of a 'Script Task', I would use a 'Precedence Constraint' to modify the flow if necessary. By writing a simple expression to determine if the variable assigned to in the 'Script Task' is greater than zero you could either continue with required work or direct to an error flow. <br> Thats pretty much all for today... <br> <br> <br> Tight Lines!! <br> <br> <br> --Chris <img width="0" height="0" src="http://www.centralflsoftware.com/blog/aggbug.ashx?id=6df0cdec-07bc-4b41-b74a-818e5589367d" /> http://www.centralflsoftware.com/blog/CommentView,guid,6df0cdec-07bc-4b41-b74a-818e5589367d.aspx SSIS