Koen is correct regarding the learning curve for SSIS, for that matter any integration tool such as ODI or Informatica have their initial learning curves that will produce frustrations along...

It looks like your manifest.txt may be tabbed delimited, or delimited in some manner. Why not use a flat file source within a data flow? The "rows" header (and...

http://www.sqlchick.com/entries/2010/9/11/displaying-fixed-number-of-rows-per-ssrs-report-page.html

Based on the original question posted, this is what you needed:

= CountDistinct(IIF(Fields!Column1.Value="ValueOfInterest", Fields!ColumnForDistinctCount.Value,Nothing))

Actually, for RS 2005, you don't click on the matrix column. You'll have to select the matrix itself (ie. matrix1 Matrix), right click to select properties. Matrix Properties...

Select your matrix in the body of the report. Right click and select Properties. The Matrix Properties dialog box pops up. Go to the Groups tab. ...