I am having difficulty connecting an ole db connection to an oracle view. When i select the View i get the following error
The output column "assignable" (3219) on the non-error output has no corresponding output column on the error output.
i have gone into the advances editor and changes the setting but i get the following error
Error at DIS_ASSIGN_NONASSIGN [OLE DB Source ]: The data type for "output "OLE DB Source Error Output" (2980)" cannot be modified in the error "output column "ErrorCode" (2981)".
Error at DIS_ASSIGN_NONASSIGN [OLE DB Source ]: Failed to set property "DataType" on "output column "ErrorCode" (2981)".
I have tried everthing i know to get this data in.
I Have tried to cast the column in the sql command window. When i try to preview it i get ORA-00905: missing key word
below is my code
SELECT SITE, BUILDING, FLOOR, ROOM,
CAST (ASSIGNABLE AS DECIMAL(10, 4)) AS ASSIGNABLE , CAST (NON_ASSIGNABLE AS DECIMAL(10, 4)) AS NON_ASSIGNABLE