Is SSIS therefore the right choice to export your data? it almost sounds like you're just simply exporting data out of a SQL table.

Would it not be easier to export...

I do the same when in SSIS. I would actually prefer, at least in...

This doesn't really sound like an SSIS task, no. Generally SSIS is used for ETL, and what you're doing here is simply checking the data and notifying someone via email....

True, I was somewhat lazy and didn't include 0 values.

This should work, however, see my below point:

CREATE TABLE #Order (OrderID INT IDENTITY (1,1),

...

What are you aiming your data to look like? We then know what you're trying to make from the data you have.

Also, it looks like your sample data contains a...

This is a 6 year old topic you've just "necro'd", it's unlikely that they're going to still have it now.

You'd be better off...

Without included the DDL of your table (Report_Run_Date does exist in TABLE1, right?) and view this is a little hard, however, your query looks wrong anyway.

This would likely work...

Although changing the orientation might be possible by simply using a page count, I don't think it's going to provide you with what you want. The issue being is that...

I know you've said that the data quality is poor, but what does converting the files from csv to xlsx actually achiev,e(and how are you doing so?

Just loading a csv...

Phil Parkin (9/27/2016)

As SSMS now...

You can format a text box by right clicking it and selecting Textbox properties. Then in the format/text pane (I can't remember what it called, and i don't have SSRS...

Most likely Kerboros is enabled on your server (you can check by running the below SQL, which should return "KERBOROS"), however, that the double hop isn't working.SELECT c.auth_scheme FROM sys.dm_exec_connections...

It definitely sounds like a permission problem then. My guess is that you're execute the package in the SSIS Catalog via T-SQL (you didn't answer this question), and your Kerboros...

I might be missing something here, but masterContacts.[Mailing Address Line 1] contains no records that have the value N'North Middlesex University Hospital NHS Trust'. Your where clause is filtering on...