Posts 24
How do I convert as/400 time field being seen as dt_I8 to string
I am struggling getting a time field from as/400 into SQL 200 using SSIS. The time field for some reason is being seen as dt_I8, And every type of conversion I try to do with it, it gives me an error about truncation. Example of my time field 12.35.00
How do you convert time field from as/400 which sql is seeing as DT_I8 to a string so that I can combine it with a date field to put it into a database timestamp field.
I have tried the following using a derived column transformation to convert my time that is seen as integer but it's failing.
(DT_WSTR,8)(DT_I8)DSRHTIME and defined it as string 8 since date field is 8 characters. I even expanded it to 10 but still fails. with same error. What am I doing wrong?
Error: 0xC020902A at Copy SalesHeaderRetail, Create Date Fields as String [6453]: The "component "Create Date Fields as String" (6453)" failed because truncation occurred, and the truncation row disposition on "output column "Tran_Time_String" (8960)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component.
Stacy
How do I convert as/400 time field being seen as dt_I8 to string
I am struggling getting a time field from as/400 into SQL 200 using SSIS. The time field for some reason is being seen as dt_I8, And every type of conversion I try to do with it, it gives me an error about truncation. Example of my time field 12.35.00
How do you convert time field from as/400 which sql is seeing as DT_I8 to a string so that I can combine it with a date field to put it into a database timestamp field.
I have tried the following using a derived column transformation to convert my time that is seen as integer but it's failing.
(DT_WSTR,8)(DT_I8)DSRHTIME and defined it as string 8 since date field is 8 characters. I even expanded it to 10 but still fails. with same error. What am I doing wrong?
Error: 0xC020902A at Copy SalesHeaderRetail, Create Date Fields as String [6453]: The "component "Create Date Fields as String" (6453)" failed because truncation occurred, and the truncation row disposition on "output column "Tran_Time_String" (8960)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component.
Stacy