﻿<?xml version='1.0' encoding='UTF-8'?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/"><channel><title>SQLServerCentral / Integration Services / Data Warehousing  / Best Practice / Latest Posts</title><generator>InstantForum.NET v2.9.0</generator><description>SQLServerCentral</description><link>http://www.sqlservercentral.com/Forums/</link><webMaster>notifications@sqlservercentral.com</webMaster><lastBuildDate>Sat, 25 May 2013 23:06:16 GMT</lastBuildDate><ttl>20</ttl><item><title>RE: Best Practice</title><link>http://www.sqlservercentral.com/Forums/Topic1382456-364-1.aspx</link><description>OK...thanks.</description><pubDate>Fri, 09 Nov 2012 10:02:18 GMT</pubDate><dc:creator>CGSJohnson</dc:creator></item><item><title>RE: Best Practice</title><link>http://www.sqlservercentral.com/Forums/Topic1382456-364-1.aspx</link><description>For the sake of readability I use option B. But this is a personal choice.</description><pubDate>Fri, 09 Nov 2012 00:33:29 GMT</pubDate><dc:creator>Koen Verbeeck</dc:creator></item><item><title>RE: Best Practice</title><link>http://www.sqlservercentral.com/Forums/Topic1382456-364-1.aspx</link><description>Thanks for the reply.</description><pubDate>Thu, 08 Nov 2012 07:29:43 GMT</pubDate><dc:creator>CGSJohnson</dc:creator></item><item><title>RE: Best Practice</title><link>http://www.sqlservercentral.com/Forums/Topic1382456-364-1.aspx</link><description>I'm accustomed to using the package variable, not a script-local one.  But that's habit, not something based on actually comparing efficiency/performance/anything.</description><pubDate>Thu, 08 Nov 2012 07:23:23 GMT</pubDate><dc:creator>GSquared</dc:creator></item><item><title>Best Practice</title><link>http://www.sqlservercentral.com/Forums/Topic1382456-364-1.aspx</link><description>Good morning. I just have a quick question for you folks.  Do you know if when using a Script task in SSIS, is it best practice to create a local variable to hold a value from a variable created at the package or container level, as opposed to just reading directly from the package/container-level variable?  For example, out of scenarios A and B below, which is better/best practices?A:MessageBox.Show(Dts.Variables["strErrorDescription"].Value.ToString());B:string errDesc = Dts.Variables["strErrorDescription"].Value.ToString();MessageBox.Show(errDesc);Thanks...Chris</description><pubDate>Thu, 08 Nov 2012 06:20:23 GMT</pubDate><dc:creator>CGSJohnson</dc:creator></item></channel></rss>