Thank you for reply, Phil!

Here's the data generator. Still working on the output.

---------------------

CREATE TABLE [dbo].[Orders](

[OrderNumber] [int] NOT NULL,

[ItemNumber] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[ItemDescription] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[Book] [int] NULL,

[OtherItem] [int] NULL,

[WeightEach]...

🙁

Look like it doesn't work inside the OLE DB Source of SSIS (?)

Worked like a dream! 😎 Totally amazing.

Do you think it'll survive ForEachLoop in SSIS (SQL command text filed of a source query to be exact)?

Something like this:

--------------------------------------

......

SELECT...

Thank you, SQLRNNR! 🙂

Apparently, we are running the Standard version of SQL 2005 server, which doesn’t support Data driven subscriptions .. What a joy!

That looks cool. Will give a try next week.

Thank you, Jeff Moden! 🙂

Finally made this work! And used for a few more reports since then.

Thank you very much for all your help, GSquared 🙂

Thanks you for sticking around.

I added Execute SQL Task to the Control Flow window with the following parameters:

Full result set

OLE DB

MyDatabase (created new connection to the MyDatabase.Table1)

Direct input

Query1

Added User::mail under...

Thank you for reply, GSquared! 🙂

I have two servers 7 and 2005. Never worked with SSIS, but just looked it up, and it appears to be a part of...