karthick.alangattan (2/27/2013)
How to convert datetime to string format (YYYYMMDD) in SSIS?I have done using Datepart but for the date 01 to 09 it gives the values as 1 to 9. I need values should be as 01. Anybody guide me
You can get round the issue you mentioned by doing something like this (untested):
right("0" + Datepart(...), 2)
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.