It is not easy to query the content of packages which have been deployed to SSISDB, because the deployment process also encrypts the package contents.

But assuming you have all of...

I can't find the option either.

But try navigating to https://www.sqlservercentral.com/forums/user/<username>/messages/

That worked for me.

Might this work?

select s.Shipment_No, p.pkg_no, l.ord_no  -- You need to get ord_no from either s or p instead
from wsPKGShipment s
left join wsPKG p
ON s.Shipment_No = p.Shipment_No
where...

Nothing obvious comes to mind.

But as it's a dev environment, I'd be fairly brutal. Taking all of the User databases offline for a month and waiting for complaints is one...

What does your desired output look like? Is a list of all the source rows which are different good enough? Or do you want to see differences at the data-item...

• This reply was modified 4 years, 9 months ago by Phil Parkin.

1. Write a query to identify...

That is looking good to me – my sample data was incorrect. I was also thinking that a recursive solution was required, good stuff.

Good start, Ken.

In case others are interested in refining his, here is some sample data which trips up the solution:

INSERT #TestSUM
(
    ProductID
  ...

It was intended as a reminder to do some research yourself before posting here and getting other people to do it for you.

As a...

Had you done a quick Google search, as I did, you should have found this, which seems to do the trick:

https://stackoverflow.com/questions/2641068/sql-server-find-and-replace-in-text-field

That is it, thanks Scott!

Thanks for your input, Jonathan.

The single query method did not work, even after changing s2.Value to s2.ColName in the necessary spots.

I have gone ahead with the multiple-batch version (there are...

As you have not provided us with any sample DDL or data, we cannot give you a coded solution. But the answer to the question: "Can queries in SQL Server...

You can do this using REVERSE, or a splitter (link). A splitter provides a more flexible and elegant solution, in my opinion:

DROP TABLE IF EXISTS #sample;

CREATE...

Then add a switch to the code … this sort of thing:

IF (DEV)
    DEBUGMODE="Verbose" 
ELSE...