manibad (4/19/2013)

---

I found a method to achieve my goal in derived column in SSIS.

the code is:

((SUBSTRING(Variable,3,1)=="/"&&SUBSTRING(Variable,6,1)=="/")||

(SUBSTRING(Variable,3,1)=="/"&&SUBSTRING(Variable,5,1)=="/")||

(SUBSTRING(Variable,2,1)=="/"&&SUBSTRING(Variable,4,1)=="/")||

(SUBSTRING(Variable,2,1)=="/"&&SUBSTRING(Variable,5,1)=="/")||

(SUBSTRING(Variable,3,1)=="-"&&SUBSTRING(Variable,6,1)=="-")||

(SUBSTRING(Variable,3,1)=="-"&&SUBSTRING(Variable,5,1)=="-")||

(SUBSTRING(Variable,2,1)=="-"&&SUBSTRING(Variable,4,1)=="-")||

(SUBSTRING(Variable,2,1)=="-"&&SUBSTRING(Variable,5,1)=="-"))?

(DT_STR,8,1252)(REPLACE((DT_WSTR,10)(DT_DBDATE)Variable,"-","")):REPLICATE(" ",8)

but here in this code i have a glitch..

the glitch is if suppose the data is like xx/yy/mmmm then it will throw a error..and i dunno how to rectify this glltch.for now we haven't stored such sort of data but still i want to rectify this glitch so can anyone please help me.

Thanks in advance.