Heh... thanks for posting your solution. I guess that's why I don't like DTS or SSIS... T-SQL makes it so much simpler...
DECLARE @SomeDate VARCHAR(8)
SET @SomeDate = '20090311'
SELECT CAST(@SomeDate AS DATETIME) AS DateTimeDataType
--Jeff Moden
Change is inevitable... Change for the better is not.