Unfortunately it is a system I have inherited and the table holds 6.8 million rows there is another column that flags if the second column is a child ID...
Many thanks for the reply, one thing i did not demonstrate in my sample (sorry, me being stupid) is that the parent or child could appear in either column, which...
I have done a similar thing with SSIS, you just need to add the new monitored instance into a table in your repository and ensure the account running the package...