Okay. so why are you using TFS, or for that matter, ANY kind of source control software, to manage SSIS projects?   I wouldn't do that unless I was being paid...

I finally found the solution.   While the "Editor" and "Advanced Editor" for the Flat File Destination do NOT have the ability to use an expression, it turns out that such...

I can't actually imagine why you would want to use the project deployment model and then try to use package deployments... that just doesn't make much sense.   There's no real...

Oh.. and I don't post anywhere near as often as I used to... and it's cause I'm a lot busier than I've ever been, so I hadn't even noticed that...

Turns out I was chasing an OLD problem... so it was kind of moot once I realized what was going on...  Our SSIS package had been ignoring a column entirely,...

Signature fixed to what it is supposed to be.

Thanks for the reply, Jeff...    I'll just have to do this manually then, as I don't really have the time right now to write the code...

As to my signature...

I can't wait for the 2022 Developer's Edition to come out so I can test.  I normally don't bother with public test versions and won't with 2022 either.  That...

That's some pretty awesome feedback, Steve.  Glad all of it worked out and thanks for posting what you did.  Glad the splitter and the modifications you made worked as...

Actually, you'll need the DBA to recreate the replication.   Steps are:

1.) Stop the existing replication.

2.) TRUNCATE the destination table.

3.) DBA sets up replication again between the two.

Once you are out...

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...