Wednesday 17 June 2020

SSIS Interview Questions (Scenario based)


Session 3 (Scenario based)


  • What type of Transformations are used to Run 10 Packages at a time?
  • Load 1 GB text file into table (fastest method) & Why?
  • Issue in package (It is failed) but is not impact on SQL Server Agent Job & Why?
  • How to Deploy the package into UAT/PROD & Explain various deployment options & which one is best in Real time?
  • How to run the package in various environments without Configuration ?
  • Explain the process flow to load 100 files into table and each file contains some more tabs & sometimes the excel files contains un structure data also . How to handle this case?
  • Excel source need to load into SQL -- Which transformation is used in the package?
  • How to use temp table throughout the package ?
  • Package should not run when there is no file and should run if file is present? How do you create this package?
  • Conditional split (it won’t work for multiple columns)
  • How to load multiple files with different names from single folder?
  • How to load multiple sheets from a single excel file?
  • How to you debug a failed package at data flow level?
  • How to use a temp table in all of the package? what are the properties we need to set?
  • replacement of OLEDB command
  • If using .csv files, what are the issues are faced
  • Excel File
    SQL
    SQL
    Table A
    Table 
    B
    Table C
     How to get the joining data from Table A,B & C in SSIS?
  • Explain step by step process to get the 10 Tables data from Oracle server to SQL Server using SSIS & without SSIS?
  • How to create the checkpoint? If check point log is deleted in which point onward the package will run?
  • Where you can specify checkpoint and Transaction
  • SCD 6 & SCD 2 scenario
  • How to change the configuration of package on Run time?                         More ....