Hey Scott, I get it. You were trying to show how different syntax might yield same results...perhaps to expose underlying logic of the original query I posted in the opening...

OK. I'm interested.

yes I see now.

The 'n' in the second to last CTE of the original query that I posted called Test(n) refers to the row_number values assigned to n column in...

OK, what a day of goodness from remote corners

I most of all appreciate Jeff Moden’s top to bottom explanation of the query, but all posts deepened the understanding of...

OK folks, just so you know, I've been reading and re-reading these replies, especially Jeff Moden's to make sure everything is completely clear to me. Then, after that if...

ok, looking forward to it and thanks. I see it is not so easy.

oh man aaron, why did you do that? Now we hazard to leave out other names like dwain.c, SeanLange, jeff Moden, ChrisM@Work, and ofcourse others that don't immediately come...

Ooooh, I didn't interpret the lower case f's as intended 😉

Phil, you're really a great resource on these forums and have helped a huge amount in my past three years....

No Phil, that is not correct. You wrote to go to Advanced Editor of Flat File Source. But you didn't say to go to the Connection Manager for...

I thought I'd share what solved this issue.

In the Flat File Connection Manager Editor (r-click and select Edit on the Connection Manager itself, not the Flat File Source Data Flow...

I've added a Data Conversion Task between the FF Source and OLEDB Destination for the Counter column, to make sure that it is passing as Data Type string[DT_STR] to OLEDB...

You need to trace the path of the data, from flat file source to destination, using the Advanced Editor to view the data types that SSIS is using as the...

this what worked

where countername like '%[%]%usage%'

or countername like '%[%]%idle%'

or countername like '%[%]%processor%'

regarding prior reply about Unicode - I'm not getting error pertaining to Unicode/non-Unicode and 80,000 rows ARE transferring.

How would I determine if it's line terminators?

The files for installing OData connection manager should be here, but they are not at this time.

http://msdn.microsoft.com/en-us/library/dn584132(v=sql.120).aspx