I know this is an old question. However my reply maybe helpful for someone.

I passed the 70-466 exam with the help of; - http://www.selftestsoftware.com/certtestprep/practice-test/microsoft/70-466.kap.

Continual reference to; -

I've opened the csv file in notepad and not noticed anything strange characters there. To be honest I don't think there is a problem with rouge characters in the source...

OK, Thanks again for your response. I need to annonimize the column names and data with everything else I have on this may take me a week.

Thanks again for your...

I've just exported the spreadsheet as a tab delimited file which contained a single record.

I then changed the File Connection Data flow / Connection Manager to specify the tab delimiter.

When...

OK, thank you.

Kieran.

OK Thanks. There are some helpful hints here.

Kind Regards,

Kieran.

Hi thanks for getting back to me. I guess I will need to do a bit of DotNet coding to create a customised feature to do the conversion from Excel...

Sorry, I'm replying to my own post!

Basically I missed a parameter on the main report which the sub report expects. Once I added the missing parameter the sub report worked...