im getting a ERRORS when converting datatypes through SSIS. please advice me the possible ways to get rid of these
August 30th, 2012 1:00pm
You should post this question in SSIS forum instead of T-SQL forum. And please include the error message with some description on what you are doing. I can hardly read the error from the pic.
Free Windows Admin Tool Kit Click here and download it now
August 30th, 2012 2:17pm
Could you please post some sample data?
August 30th, 2012 2:35pm
atlast i got it by the following code
SELECT
CAST(CAST(Nextcycledate AS VARCHAR(8)) AS DATETIME),
case WHEN LEN(LTRIM(RTrIM(OPENDATE))) = 5
then CAST(CAST(('20' + '0' +LTRIM(RTrIM(OPENDATE))) AS VARCHAR(8)) AS DATETIME)
when LEN(LTRIM(RTrIM(OPENDATE))) = 6
then CAST(CAST(('20' +LTRIM(RTrIM(OPENDATE))) AS VARCHAR(8)) AS DATETIME)
end AS OPENDATE
Free Windows Admin Tool Kit Click here and download it now
August 30th, 2012 4:32pm