I need to create SSIS package with user entered date parameter. I have two questions:
1. How I can promt the parameter when I test the package in debyg mode.
2. How can I put on the begining of the package design condition:
Global Variable gvar_Date datetime;
If @p_Date is null Then gvar_Date = getdate()
Else gvar_Date= @p_Date
Thank you for your respond
IG
Discuss This Question: