I could do that. I was trying to make sure I had it all installed correctly before going on to harder things. SSIS is bad enough for me as is,...

Just to make sure I wasn't doing something really stupid, I ran the Import wizard from SSMS, and tried to import the same data saved as a Text file.  The...

Did that already too. =(  That's why I'm completely perplexed by this one.  What else did I miss?

Then explain in plain English how that's supposed to happen. Once I know that, I can probably code it.

first you'd have to post the definitions of views 1, 2, and 3.

SELECT Client_ID
    , MAX([Amount]) AS MaxAmount
FROM ##TEMP
WHERE Amount>0
GROUP BY Client_ID;

without some CREATE TABLE statements and some consumable sample data, there's no way for anyone to really help you. Please read this article and follow the instructions so...

I posted a link to Jeff's article so you would read it. One of the keys to getting an answer is asking a good question, and Jeff explains how to...

Could you post your expected completed pivot given the data provided?

Did you read Jeff Moden's article about crosstabs/pivots in T-SQL?

"Not working" is not terribly helpful when diagnosing a query.
post the T-SQL for your query and maybe we can help.

For someone that's been here as long as...

Look up examples for CROSS APPLY and TOP...  Here's Itzik's example from Itzik Ben-Gan on SQL 2008

SELECT D.orderID, D.productID, D.qty
FROM Sales.Orders AS O
CROSS APPLY 

use a correlated subquery and [NOT] EXISTS to find parent records with/without child records.  Just too lazy/tired to sort out the mess without sample data.

Got some table definitions and some sample data and some expected results? You know, same old same old.

False. This is an SSIS question.