Am trying to populate a snapshot fact table, i decided to add a derived column to get the current date but then i need to write an expression to convert the date into integer value as my destination is integer. this is my expression (DT_WSTR,30)(DT_DBDATE)GETDATE() and i did the data conversation to four-bye signed which brought the error below.
any help on how to convert the current date to an integer so i can mapped the source and the destination correctly..
[Get Today's Date ] Error: An error occurred while attempting to perform data conversion. The source type could not be converted to the destination type.
[Get Today's Date ] Error: SSIS Error Code
DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "component "Get Today's Date" (902)" failed because error code 0xC0049062 occurred, and the error row disposition on "output column "TodaysDate" (908)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.