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()"

No comments:

Post a Comment