Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Error redirect output file does not contain the error columns ErrorCode and ErrorColumn

Answered Error redirect output file does not contain the error columns ErrorCode and ErrorColumn

  • Friday, January 04, 2013 11:45 PM
     
     
    Sign In to Vote
    0

    I redirect error output to a text file, but I only see the bad record and cannot see the two error columns, ErrorCode and ErrorColumn.  Please help.

    BI Analyst

     

All Replies

  • Saturday, January 05, 2013 11:17 AM
    Moderator
     
     
    Sign In to Vote
    1

    I redirect error output to a text file, but I only see the bad record and cannot see the two error columns, ErrorCode and ErrorColumn.  Please help.

    BI Analyst


    Are the columns mapped in the Destination Component?

    Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter


     
  • Saturday, January 05, 2013 1:54 PM
     
     
    Sign In to Vote
    1

    Hi,

          try this link - http://sathyadb.blogspot.in/2012/09/sql-server-integration-services-error.html

    Thanks & Regards, sathya

     
  • Saturday, January 05, 2013 4:06 PM
     
     
    Sign In to Vote
    0

    Hi SSISJoost,

    No, I cannot see the two columns in the Available Destination window.  I have done error redirect output task before and most of the time, I can see them being mapping perfectly, but on this particular task, I have no idea why the two error columns do not even show up in the Available Destination window.

    BI Analyst

     
  • Saturday, January 05, 2013 4:32 PM
     
     
    Sign In to Vote
    0

    Hi Sathya,

    Thank you for your tip.  I do not have an Output Column node.  I only see External Column and Input Column.  And I do not have ErrorRowDisposition & TruncationRowDisposition in the property on either one of them.  I think you are using 2012 and I am using 2008.

    BI Analyst

     
  • Saturday, January 05, 2013 5:16 PM
    Moderator
     
     
    Sign In to Vote
    0

    Hi SSISJoost,

    No, I cannot see the two columns in the Available Destination window.  I have done error redirect output task before and most of the time, I can see them being mapping perfectly, but on this particular task, I have no idea why the two error columns do not even show up in the Available Destination window.

    BI Analyst

    They should be available in the "Available Input Columns". If they don't exist in the "Available Destination Columns" then you need to adust the Flat File Connection Manager.

    If they are also not available in the "Available Input Columns" then it's probably the easiest to remove the source component from the Data Flow Task and recreate it...

    Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

     
  • Saturday, January 05, 2013 6:44 PM
     
     
    Sign In to Vote
    0

    Hi SSISJoost,

    I cannot see them in the Input Columns node.  What type of adjustment do I need to do on the Flat File Connection Manager?  


    BI Analyst

     
  • Saturday, January 05, 2013 8:26 PM
    Moderator
     
     Answered
    Sign In to Vote
    1

    Hi SSISJoost,

    I cannot see them in the Input Columns node.  What type of adjustment do I need to do on the Flat File Connection Manager?  


    BI Analyst


    None yet... they are missing in the input columns. It's probably the easiest to remove the source component (where your error flow is comming from) and recreate it... then check if the columns are in the output port (Advanced editor on source component).

    Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

    • Marked As Answer by BIAnalyst Sunday, January 06, 2013 1:20 AM
    •  
     
  • Sunday, January 06, 2013 1:25 AM
     
     
    Sign In to Vote
    0

    Thanks, that does the job!  :)

    BI Analyst