This is design question. I am tasked to create SSIS framework. Part of this framework is logging component. I am aware of basic logging feature of SSIS. However, my task is to come up with a logging component that can be used across company. In framework, other teams will add more projects. Project A (which is part of framework) can use this logging component and it will be stored projectA.logProject B (which is part of framework) can use this logging component and it will be stored projectB.log and so forth. This logging component should rotate weekly. That means projectA_monday.log, projectA_tuesday.log. Next Monday, log will be overwritten. However, on same day, you should be able to see all entries for projectA I would love to hear your advice for this. I have already log file which does step 3, but I am not sure how to start framework and logging component for other projects. Will appreciate your advice and suggestion/solution

May be you can create a SSIS package template, it includes the logging component (Logging component can be a script component or other component), then everyone create their packages base on your template. They will see the template when they create a new package. Please refer to http://support.microsoft.com/kb/908018 How to create a package template in SQL Server Business Intelligence Development Studio You also need some configurations to assign the log name to log files. For example, you can define LogFile_Name and LogFile_Date as package variables, then ask different project team to configure variable - LogFile_Name. If I am from project A, I assign value 'ProjectA' to 'LogFile_Name', LogFile_Date can be got day by day, the value you need to use expression. Then 'LogFile_Name'+'_'+'LogFile_Date' could be you file name. Another way is you can design a custom logging component in SSIS package, everyone can drag it from control flow or data flow. Please refer to - http://msdn.microsoft.com/en-us/library/ms136078.aspx I suggest you use the package template. Please vote if it's helpful and mark it as an answer!

Thanks Simon I will review the articles mentioned.