I need some ssis Scenarios
-
31 Mei 2011 14:00Hi.....some confuse in logging plz explain this topic. send any scenario plz.
Semua Balasan
-
01 Juni 2011 2:15ModeratorCan 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 -
10 Juni 2011 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. -
14 Juni 2011 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- Ditandai sebagai Jawaban oleh Mr. WhartyMicrosoft Community Contributor, Moderator 25 Mei 2012 4:36
