rc
asked on
Expression Builder - SSIS 2008
Hello Experts,
I have a variable created in my package as StartDate (DataType: String). The value of that variable is set at run time, the value look like 3/6/2013. I want to convert this into "20130306" and set it to another varaible. Please help me with the query.
Thanks a lot!!!
I have a variable created in my package as StartDate (DataType: String). The value of that variable is set at run time, the value look like 3/6/2013. I want to convert this into "20130306" and set it to another varaible. Please help me with the query.
Thanks a lot!!!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I want to do this in Expression Builder of SSIS. I dont think we can use CONVERT() function.
the second query you sent me will work in SSMS, but in SSIS I have to write an expression in the user variable.