knamc
asked on
SSIS Expression converted from SQL
Hi I am very new to SSIS and I have a derived column that I want to use an expression to set the date, I have the following SQL statement, how do I convert to SSIS
(CAST(CONVERT(CHAR(8), getdate(), 112) AS DATEtime) ) -88
(CAST(CONVERT(CHAR(8), getdate(), 112) AS DATEtime) ) -88
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
(DT_WSTR,4)YEAR(GETDATE()) + RIGHT("0" + (DT_WSTR,2)MONTH(GETDATE() ), 2) + RIGHT("0" + (DT_WSTR,2)DAY( GETDATE()), 2)