• I met with another problem. Lets say using the same package variable ExecDate, data type : String, Default value : "Default"

    So if my batch file pass a date parameters to the variable it will used the date pass, else it shall use today date and not the value "Default". How to do this in a Execute SQL task? I got a statement of

    Delete From T1 Where creationDate = ?

    This wont work as i wont want the value "Default". Any advice? My column creationDate is of datetime type

    thanks