I can think of two approaches.

First come up with a process to test the target for the last date loaded and then use that information to query the source appropriately.

Second...

gag me...

It sounds like you have the enterprise version of SQL Server, so the first issue is out of the way. A data driven subscription will create a distinct report...

smooth

If you set up a proxy with the appropriate mail server access and ran the SSIS package under the security context of the proxy that should work. You should...

It sounds as though your hands are tied and you don't really have good options. The only thing you haven't ruled out is to do a comparison of the...

I don't see any SUM in your expression. But I have not had much luck doing conditional sum in SSRS and I usually add columns to the dataset that...

breached

Skip the data flow. Create a for each loop based on an enumeration of source tables. Inside the for each loop put a Execute SQL Task with your...

soaker

That's what I call good parenting 😀

Lemon drop

Make sure that the your package knows where to find the proper config file. It must be the exact same path in either environment like C:\configFilepath\configfile.dtsconfig. If the...

Is there a header row that you are counting that does not contain actual data?

Look at your target table and try to determine if it is the first or last...

Try this

DATEADD("dd",-1,DATEADD("mm",DATEDIFF("mm","1901-01-01",Today())+5,"1901-01-01"))