Audit Transformation error

Hello all,

I am getting an error that I am stuck on. I dragged the Audit Transformation for error handling (Flat File Source); however, the Audit Transformation is returning an error for one of the standard column "User name". I tried to change the length or take out this column, but the error does not go away. Below is the error message. Your help is much appreciated!

-Lawrence

"The length for "output column "User name" (195)" is not valid for the specified lineage item."

"component "Audit" (180)" failed validation and returned validation status "VS_ISBROKEN".

Do you get the error immediately after dragging the Audit component on or after you have made some changes?

Is [User name] a column from the Flat File Source? If so, what is the length of it?

Regards

Jamie

|||

Jamie, "User Name" is one of the 8 items we allow users to monitor thru an Audit transform, in other words it is an output column (type dt_wstr) from Audit if customer chooses to add this.

Lawrence, the default length on this col is 64, you must have changed it somehow. If you use the advanced editor and change the length on the exact output column to >=13, you should be fine.

thanks

wenyang

|||

Wenyang Hu wrote:

Jamie, "User Name" is one of the 8 items we allow users to monitor thru an Audit transform, in other words it is an output column (type dt_wstr) from Audit if customer chooses to add this.

Yeah I know. I was just checking there wasn't a column of that name on the source!

-Jamie

|||

Hello Wenyang,

I am NOT finding the Advanced editor that you mentioned. From Books Online, I cannot find "Show Advanced Editor". Can you tell me why I am not getting that screen to modify User Name length?

Below is the Data Flow Path coming out of the Audit Transformation. As you can see, User Name has length 14 (not seeing the default length of 64 for this col).

'Name''Data Type''Precision''Scale''Length''Code Page''Sort Key Position''Comparison Flags''Source Component'
'Flat File Source Error Output Column''DT_TEXT''0''0''0''1252''0''''Flat File Source'
'ErrorCode''DT_I4''0''0''0''0''0''''Flat File Source'
'ErrorColumn''DT_I4''0''0''0''0''0''''Flat File Source'
'Execution instance GUID''DT_GUID''0''0''0''0''0''''Audit'
'Package ID''DT_GUID''0''0''0''0''0''''Audit'
'Package name''DT_WSTR''0''0''17''0''0''''Audit'
'Version ID''DT_GUID''0''0''0''0''0''''Audit'
'Execution start time''DT_DATE''0''0''0''0''0''''Audit'
'Machine name''DT_WSTR''0''0''15''0''0''''Audit'
'User name''DT_WSTR''0''0''14''0''0''''Audit'
'Task name''DT_WSTR''0''0''26''0''0''''Audit'
'Task ID''DT_GUID''0''0''0''0''0''''Audit'

|||

You access the advanced editor by right-clicking on the component and selecting "Show Advanced Editor".

-Jamie