I just found out about the Trace File Source Adapter available from SQLIS.com. This tool will allow you to read a SQL 2005/2008 trace file within an SSIS package. I learned about it from this entry on Chris Webb’s blog.
I have not used or even downloaded it yet, but I will as I am interested in all things Trace/Profiler related. It looks interesting although I don’t see a compelling use for it at this point. I am firm believer in being aware of the tools available and this is another one to add to the toolbox.