That's good advice from Frederico.

Sorts in SSIS are to be avoided if possible, as they are blocking components and perform very much worse than in-database sorts.

If your tables reside on...

You could build the pivot dynamically in T-SQL (sample link), but getting that out of SSIS and into Excel is extremely tricky, because SSIS likes to know its columns...

It's been a while since I've had to do this, so I just created a dummy package to work it out again.

Here are the steps that I took:

1. In your...

Are you confirming that you have done as I suggested and that the same error occurs?

If you don't need NAME at all, take it out of the data flow by going into the data source advanced editor / column mappings and setting Output Column to...

OK, those errors are actually pretty helpful.

There must be one or more occurrences of the column NAME in file

ADAP.O#Adaptimmune Therapeutics ADR Representing 6 Ord Shs (D).csv

where the data is longer...

• This reply was modified 2 weeks, 5 days ago by  Phil Parkin. Reason: Fix typo

Were you logged in as a SQL Server user or a Windows user when you tried this?

Are the 'could not find' objects still present? Eg, Is_Valid_Name should be here:

I'm trying to run through SQL Agent job. Only issue is coming in the packages where transformations like Multicast, conditional Spilt etc. are being used.

When run directly through Visual...

Can people please use the {} Code tags when posting code, as it makes it so much easier to read.

DROP TABLE IF EXISTS #SomeData;

CREATE TABLE #SomeData
(
 ...

Thanks for clarifying. No idea where those square brackets are coming from ... I just played around with some connections and cannot reproduce what you are seeing. I even tried...

I've looked again at your pics...

Hi Phil,

Yes, I opened the XML's as well and saw that they are not there but in the Connection Managers window they are...

"You can rename the connection manager without...

First of all, I find it odd/annoying that I can't exclude a Project level connect from a package Connection Managers... at least I can not do it. Why should they...

Create a variable and add an expression which evaluates to the exact query you want to execute. Use that variable as your source query.

If you modify the source query for the Oracle data to select where

StartDate <= LoginDate <= EndDate

, can you then do the lookup in the way that you wish?