I need some ssis Scenarios
-
Tuesday, May 31, 2011 2:00 PMHi.....some confuse in logging plz explain this topic. send any scenario plz.
All Replies
-
Wednesday, June 01, 2011 2:15 AMModeratorCan 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 -
Friday, June 10, 2011 11:50 AM
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. -
Tuesday, June 14, 2011 12:12 PM
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- Marked As Answer by Mr. WhartyMicrosoft Community Contributor, Moderator Friday, May 25, 2012 4:36 AM


