• Hey guys! Look here and see that we are discussing the same problem.

    In brief -- the element where you want to grab column names is not the one where the columns are. The columns definition happens in the previous block, which is the source of the error information for the script.

    So, there is no easy way you can do it. You are stuck with those dodgy IDs, which are visible only in the advanced UI editor.

    To access the names from within the element which generated the error you do something like this:

    CStr(ComponentMetaData.InputCollection.Item(0).InputColumnCollection(0).Name)

    but unfortunately datasource block generates the error information by itself and spits out only ErrorCode and ColumnID.

    Looks like we need to place switch or if-else block in the error processing script to determine the column names, and apparently hard-code the IDs in the script.

    I really don't want to do it since I have thousands of fields in hundreds of tables.

    Does anyone know a better way?

    M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM