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
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!