I have created a batch file to run my SSIS package. I will be able to pass parameters in my batch file such as 20121228 (YYYYMMDD format) I have created a package variable named ExecDate of string type in SSIS. And inside script task i have a line of code as:
Dim runDate As DateTime = Now
now instead of declaring runDate as current datetime, i would like to change it to if ExecDate = "Default", runDate = Now
runDate = to the parameter i passed in the batch file.
Note: my ExecDate is of String datatype
Thanks in advance, pros please help
update: i think i have solve the above problem by advising user to only pass in parameters of 2012/12/28 format and using a CDATE function to convert it to date.