I need some ssis Scenarios
-
2011年5月31日 下午 02:00Hi.....some confuse in logging plz explain this topic. send any scenario plz.
所有回覆
-
2011年6月1日 上午 02:15版主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 -
2011年6月10日 上午 11:50
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. -
2011年6月14日 下午 12:12
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 Profilerhttp://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- 已標示為解答 Mr. WhartyMicrosoft Community Contributor, Moderator 2012年5月25日 上午 04:36


