TCS Interview Questions And Answers
1. SSIS logging Logging is used to log the information during execution of package. A log provider can be a text file, the SQL Server Profiler, a SQL Server relational database, a Windows event log, or an XML file. If necessary, you can define a custom log provider (e.g., a proprietary file format). 2. Error handling Error Handling can be achieved in Data Flow Task by configuring Error Output. --> 3 actions can be performed whenever some error occurs - Ignore Failure - Redirect Row - Fail Component --> By default Fail Component is being used by SSIS --> Ignore Failure - if error occurs, SSIS will ignore that error and move ahead --> Redirect Row - if error occurs, SSIS moves those erroneous (bad) records to different destination and correct records to actual destination. 3. How to use inner join in ssis transformations? By using merge join transformation. 4. Drill down report Drilldown reports initially hide complexity and enable the user to toggle conditionally hidden rep...