Best Practice

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Integration Services » Best Practice

Best Practice

Rate Topic

Display Mode

Topic Options

Author

Message

CGSJohnson

Posted Thursday, November 08, 2012 6:20 AM

Ten Centuries

Group: General Forum Members
Last Login: Monday, May 20, 2013 1:31 AM
Points: 1,385, Visits: 1,085

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

Post #1382456

GSquared

Posted Thursday, November 08, 2012 7:23 AM

SSCoach

Group: General Forum Members
Last Login: 2 days ago @ 1:55 PM
Points: 15,442, Visits: 9,571

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.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Post #1382486