Link to home
Create AccountLog 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
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
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.