Is it possible to script multiple queries?  I need to transfer about 30 queries from one server to another w/o copying the entire database.  I was hoping i wouldn't...

Are you using SQL Agent job to do this?

If so, it's likely that the SQL Agent user does not have the necessary rights to create the file.

Or, if the file...

Note also that it is good practice to

a) Explicitly name the columns you are INSERTing to

b) Avoid SELECT * (unless the number of columns and their names has no effect...

You have stated your requirement, but what is your question? What have you tried and what were the results?

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.