I do not understand how your data is ordered – it is neither Col1 nor Col2. Please explain, because without explicit ordering, I do not think that this problem can...

Ideally, all of your DDL should be happening outside of SSIS. Can't tell whether this is the case here.

Use derived columns within your SSIS data flow to populate the non-nullable...

I can't see anything useful in that stack trace. Were there other error messages generated before the trace? Have you identified the exact statement which generates the error by running...

Just noticed that this is a 2012 forum. You'll have to use the old FOR XML PATH method to do the concatenation.

Here's a SELECT query which does the concatenation. I'm sure that you can change it into a conditional UPDATE.

DROP TABLE IF EXISTS #TableA;

CREATE TABLE #TableA
(
  ...

Just enter some dummy (but valid) values for the parameters and it should work.  SSRS does this when it believes that things have become too complicated for it to guess...

I've read through the question a couple of times and I don't understand what you are trying to achieve.

Can you provide your sample data in consumable format, along with an...

Decide what you want to happen in these cases ... how to 'get around it' will depend on your desired outcome.

Shift all parameters 1.5 bytes to the left and start the run.  In 30ms, stop the run and then restart it.  Note that you have to do this your...

Can you find them here?

https://catalog.update.microsoft.com/search.aspx?q=sql+server

--Edit: remove duplicate post

• This reply was modified 2 years, 1 month ago by Phil Parkin.

Hi,

I have 2 tabs created in SSRS Report.There is calendar Day prompt in the report. By Selecting the Calendar Day Prompt the 2nd tab displayed in the report varies...

I've never used it and therefore don't...

Dead right about Power BI and source control. It feels like MS never anticipated that Power BI reports would need to be subject to source control.

There are third-party apps out...

Solid logic.

I had not realised until now that it was possible to...