>>I think you are right. It is time to learn SSRS.
>>Thanks,
>>Daniel
>
>I agree with Sergey that you probably aren't using the right tool, but if your work environment is anything like mine they don't care about that and just want you to do what you can with what you have. Maybe installing Adobe Acrobat or Crystal Reports on the SQL Server and using a Script Task to call either of those components?
Other things we have done is built a .NET console app to perform tasks we thought was too complicated for SSIS. You can execute that app from SSIS.