Re: SSIS Audit Transformation error

Tech-Archive recommends: Speed Up your PC by fixing your registry



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

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



.



Relevant Pages

  • Re: Not enough storage is available to complete this operation
    ... Check to see if you have enough disk space. ... Rick ... > The following error message is received during the transformation of ...
    (microsoft.public.sqlserver.dts)
  • XSLT Brain Death has occured
    ... Trying to do a simple transformation using XSLT to a Web Page, ... failes without an error message (In other words, it bums out with a general ... Private Sub Page_Load(ByVal sender As System.Object, ... OHM ...
    (microsoft.public.dotnet.languages.vb)
  • Not enough storage is available to complete this operation
    ... The following error message is received during the transformation of ... data from a text file into SQL database. ... "Not enough storage is available to complete this operation" ...
    (microsoft.public.sqlserver.dts)
  • Help with data conversion error 8004206A
    ... Microsoft Data Transformation Services Data Pump ... : TransformCopy 'DTSTransformation__1' conversion error: General ... 8004206A Step Error Help File:sqldts80.hlp Step Error Help Context ID:0 ... I copied that error message from a previous post I found while researching ...
    (microsoft.public.sqlserver.dts)