Change data in buffer

• stricknyn

  SSCertifiable

  Points: 6560

  More actions

  January 19, 2011 at 10:11 am

  #230512

  Hi all,

  I'm doing some debugging with my SSIS package. It runs fine, but I would like to be able to change a column while the data is in the buffer to force an error to occur (kinda like a what if this happened scenario). I thought I could make this happen by adding a dataview in one of the data flow tasks, then just changing a value in one of the columns when the data viewer window pops up during run-time, but it looks like the data viewers are read only. Is there a way to do this without creating another data flow task to change the value?

  Note: I do not have access to change the value in the source DB so I need to be able to change it in the buffer.

  Thanks,

  Strick

• Koen Verbeeck

  SSC Guru

  Points: 259105

  More actions

  January 20, 2011 at 12:15 am

  #1275707

  How do you read from the source?

  If it is a relation source and you are accessing it with a SQL statement (you should), then you can just add an extra row with the UNION statement.

  Place in that extra rows the errors you need.

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