Showing posts with label globalvariable. Show all posts
Showing posts with label globalvariable. Show all posts

Wednesday, March 7, 2012

Pass sysdate value to Global Variable

Hi,

How can we pass sysdate value as default value to a GlobalVariable to SSIS?

Regards,

Mohammad Sufian

Create global variable.

Set "EvaluateAsExpression" to true in the properties list for that variable.

In the expression box, type in "getdate()"