I wish I had a solution for you... but I just can't help but ask "Why you would have wanted to delete rows in the replica?"  Given that just deleting...

Jeff...

I did eventually find VB code via Google search that identified the method needed to add to a BLOB data type within the OutputBuffer object.   So far, it has been...

Chances are, a For Each Loop Container is not going to work very well.   It's not easily parameterized for the values needed.   It would actually be easier to write a...

I guess the only way to find out is to test it, then...

Scott P. -  Just so I get a better understanding, had the OP used a TRY/CATCH set of blocks, would the cancellation of the query in SSMS have triggered the...

How about posting the solution so that everyone can benefit from the knowledge?

I just noticed that the companies are ordered in the "desired results" by the CoID.   To make that happen, here's the code, including the supplied table creation and data insert...

• This reply was modified 3 years, 2 months ago by sgmunson. Reason: Results got fouled up in formatting

I'm pretty sure you don't need multiple CTE's to accomplish this task.   Given the data supplied in the original post, the following should work (note that varchar(300) is rather wasteful...

• This reply was modified 3 years, 2 months ago by sgmunson. Reason: o instead of 0 needed fixed
• This reply was modified 3 years, 2 months ago by sgmunson. Reason: Forgot to include results

I found this topic via a Google search, and it kinda-sorta relates to my issue.   I need a Script Component in SSIS to serve as a...

I found this topic via a Google search, and it kinda-sorta relates to my issue.   I need a Script Component in SSIS to serve as a...

It now appears I may have found the solution:

Row.MyVARCHARMAXColumn.AddBlobData(System.Text.Encoding.UTF8.GetBytes("something")) or

Row.MyVARCHARMAXColumn.AddBlobData(System.Text.Encoding.ASCII.GetBytes("something"))

At least now my script doesn't generate an error for compilation.   We'll see what happens at runtime...

I found this topic via a Google search, and it kinda-sorta relates to my issue.   I need a Script Component in SSIS to serve as a data source...

I found this topic via a Google search, and it kinda-sorta relates to my issue.   I need a Script Component in SSIS to serve as a data source for an...

I'm thinking about this rather differently.   My perception of a system that is based almost entirely on a hierarchy of tags seems like it's mostly a matter of time before...

This is typically something handled by creating a trigger on the relevant tables, and is "on" all the time.   When you need to capture the actions of only a specific...