Your final resultset cannot contain a mixture of numbers of columns and datatypes. But you can create a wider dataset, eg

SELECT Col1, Col2, Col3, Col4 = NULL,...

Jeff's post says exactly what he meant to say. He did not condense his...

A quick response to some of your questions:

• All environment-specific items should be parameterised.
• Don't Save Sensitive, along with sensitive parameters whose values are passed from SSISDB environments, is the...

OK. What is your question?

That's...

Check out COUNT(x) vs COUNT(DISTINCT x)

That's not the point...

I have had mixed results getting it to restyle code for things that can't be restyled with a styling tool - such as standardizing aliasing to AS aliasing, eliminating...

A final question: why the package can run through an agent job which runs as a proxy user(also a domain user). My guess is that it only needs one...

Thank you, sir.

I believe you're correct - it's a Kerberos double-hop issue.

I checked the sql server logs on instance B and found this line. When I execute the SSIS...

A report that shows timespan of the analysis and then total for the TagID then Unique and Nonunique(differnt value)

There where 800 captures and 750 all had same value and,...

What are your desired results, based on this sample data?

One final idea. Could it be a Kerberos double-hop issue? To test this, try using SQL Server auth for your connection, rather than Windows.

The reason I mentioned it was just to make sure that you'd filled in all the parameter and connection override info on the GUI screen before submitting?

Are you using SSISDB environment variables to override connection configuration?