I've put SSIS packages in TFS source control for years, so I know it works.  My opinion is that it probably makes the most sense to keep it in source...

Also, FYI, depending on your database nomenclature, it may be better to create a synonym to this function instead of using a 3 part object name [db_name].[schema_name].[function_name]

That way...

it looks like you're trying to reference the table valued function as you would a scalar function, by putting it in the SELECT clause.  It would work better to APPLY...

so... how about that weather we've been having lately?

Does it have to be a view?  If not, you could create a stored procedure that uses the EXECUTE AS clause to run the query as a different user that...

It's a bit difficult to figure out without seeing the query behind the seek and lookup, but if the optimizer is choosing an index to seek on (SubjectVisitID, AssessmentTypeID), then...

Since you're in 2008, you can't use the more modern Windowing function methods of doing this, so you would need a self join.  So maybe something like this?
[code...

How many pages are in each table?