dbTalk Databases Forums  

SSIS Audit Transformation error

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss SSIS Audit Transformation error in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Lawrence
 
Posts: n/a

Default SSIS Audit Transformation error - 06-13-2006 , 09:30 AM






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".


Reply With Quote
  #2  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: SSIS Audit Transformation error - 06-17-2006 , 09:42 AM






Hello Lawrence,

What is the username it does not like and we can try here?

What revision of 2K5 are you using?

Have you tried to simply use a derived column transform instead and roll
your own?

Allan

Quote:
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".




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.