Link to home
Start Free TrialLog in
Avatar of rc
rcFlag for United States of America

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!!!
ASKER CERTIFIED SOLUTION
Avatar of lcohan
lcohan
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rc

ASKER

Hi lcohan,

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.