I have never used Jetbrains rider, so no. But as database properties are created in VS before the creation of any DACPACs, I suspect that it cannot be done.

Have you added the variable to the SQLCMD Variables collection in Database Properties?

I do not know the answer to your question, but I do have a suggestion. Rather than calling a stored proc to do the column-name checks, keep things inside SSIS...

Is this just a one-off, or are you designing a process which needs to run regularly and automatically?

I am as puzzled as you.

Have you tried playing around with the number of rows of comments to see how (or whether) that affects anything?

You could also try changing the...

This is what I've come up with so far.  Can someone grade me on this, or say if you think there's a better way?

with ad as...

This is a requirement, not a...

Use a query to get your data from SQL Server into SSIS and use CAST in the query to get the BLOB into string format

DROP TABLE IF...

Please provide your sample data in the form of CREATE TABLE/INSERT statements.  Also provide your desired results,  based on the sample data.

I have two unique keys in one table and I want to write a query that connects me to two unique keys and displays them in one record. Right...

That is a lot of data. Have you looked at the execution plan? Are the underlying tables appropriately keyed and indexed?

That made it more complicated than I had expected and I had to adopt a different method, unfortunately containing cascading CTEs. Does this get you close?

WITH BaseData1
AS...

Which column, or columns, of data should be considered when generating the Sales = 0 rows?

Well done on providing the sample data, though please use one or more code blocks next time.  In future, please use temp tables (avoids others having to create and drop...

OK, I see the problem. The query logic is such that the generation of a notional Sales = 0 row depends on column 'Data', not on EmpId.

In the case where...