You just responded to a six-year-old post...

Something like this (untested, because you did not provide DDL etc)?

WITH Sums
AS (SELECT Revenue = SUM([Money In])
          ,Outgoings...

Deleting your post after others have taken the time to respond, and not even thanking them, is rather rude in my opinion.

So here is a copy of the original, as...

Here's an in-line version of that image.

Jeff,

(and Steve, who's kinda busy this week) and anybody else... for grins, I did a PPT of this so I could see the hierarchy and understand what's going on...

Are you able to open the All Executions report & check the logs there?

Your approach seems more cumbersome than necessary. There's rarely any need to hard-code environment-specific parameters - just configure them to pick up the values of SSISDB environment variables.

AFAIK, Scott's solution is the better one, because LIKE 'AAA%' is potentially...

Please post the link to the T-SQL random() function that you intend to use.

Use NEWID() to force randomness.

SELECT TOP (10) PERCENT
       *
FROM sys.columns
ORDER BY NEWID();

What is your question?

And if you're looking for a coded solution, please provide some sample data (as insert statements) and desired results based on that sample data.

.SQL files are not...

No apologies are needed here!

What I assumed you did was as follows:

a) Have a sheet called AllDogs in your trial spreadsheet ... imports successfully.

b) Have a sheet called (whatever) in...

So this bit

BTW, I did try renaming the sheets after the C & P to no avail

wasn't quite true? 🙂

Changing your code to accommodate the space character should be trivial.

Can you create a couple of screenshots & paste them in, as follows:

1. Showing the trial Excel file, with headings & first 10 rows
2. Showing the prod Excel file, with...

• This reply was modified 6 years, 9 months ago by Phil Parkin. Reason: Fix typo