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.
Try creating a new column on the error output not using the ErrorCode column as that is a system column and cannot be changed.
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_ASSIGNABLEFROM FAMIS.DIS_ASSIGN_NONASSIGN
Hi - I had the same error - I deleted the OLE DEB Source, and added it again - problem went away.
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?