I need some ssis Scenarios

Question

Hi.....some confuse in logging plz explain this topic. send any scenario plz.

Answer 1

Can you please provide a little more information on what it is you're looking for as I don;t really understand your question.

---

Jeff Wharton
MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA
Blog: Mr. Wharty's Ramblings
Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker

Answer 2

Hi anichinna, do you need the concept of logging in SSIS, if so please check this : http://msdn.microsoft.com/en-us/library/ms138020.aspx. and http://msdn.microsoft.com/en-us/library/ms167456.aspx. every type of logging has its own importance. For SQL logging, security is more like encryption, where as for text logging the maintenance is easier.

---

Happy to help! Thanks. Regards and good Wishes, Deepak.

Answer 3

The logging option can be seen by clicking anywhere on the design surface of the SSIS package. When you click on the logging option, the following indow pops up, there will be SSIS package and the various tasks in SSIS package on the left. On the right hand side within the window you have two tabs Providers and Logs, Details. When you choose the Provider type there are different types available:

SSIS log provider for SQL Server,
SSIS log provider for Windows Event Log
SSIS log provider for XML Files
SSIS log provider for Text Files
SSIS log provider for Sql Server Profiler

http://msdn.microsoft.com/en-us/library/ms140246.aspx and http://sqlcat.com/top10lists/archive/2008/10/01/top-10-sql-server-integration-services-best-practices.aspx should get you more information too.

---

Satya SKJ, SQL Server MVP www.sqlserver-qa.net [knowledge sharing network]
Get knowledge sharing network feeds by Email