error column name

• sqlfriend

  SSC Guru

  Points: 52794

  More actions

  September 2, 2011 at 4:03 pm

  #244256

  I hae a ssis package, if there are errors I direct them to a table.

  But error output only have columnID, how can I manually find what are the column name?

  Thanks

• Koen Verbeeck

  SSC Guru

  Points: 259197

  More actions

  September 5, 2011 at 11:58 am

  #1377129

  Here you go:

  http://dougbert.com/blogs/dougbert/archive/2008/05/10/adding-the-error-column-name-to-an-error-output.aspx

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP

• sqlfriend

  SSC Guru

  Points: 52794

  More actions

  September 5, 2011 at 12:22 pm

  #1377137

  Thanks a lot.

  But the solution the link points to include a visual basic project that pulls column name, it cannot be opened in BIDs, and I don't have a full version of visual studio installed to open visual basic project to see how it is implented.

  Is there a simple way that I can find manually by searching the errorColumn ID somewhere and find the column name?

  Thanks

• Koen Verbeeck

  SSC Guru

  Points: 259197

  More actions

  September 5, 2011 at 12:27 pm

  #1377138

  You can use Visual Basic inside BIDS, you don't need a full version of Visual Studio.

  In the dataflow, you can select the Script Component, which launches a shell of Visual Studio where you can write your code.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP