Ssis Developer Interview Questions and Answers

To find file count in source folder and check if files exist, use SSIS Script Task with C# code.

• Create a SSIS package with Script Task

• Write C# code to get file count and check if files exist

• Use System.IO namespace to access files and folders

• Use Directory.GetFiles() method to get all files in folder

• Use File.Exists() method to check if file exists

• Use a variable to store file count and use it in subsequent tasks

Interview questions for SSIS and SQL developer

• Worked with Lookup transformation and its catch mode

• Understand the difference between Merge and Union transformations

• Familiar with containers like For Loop, Foreach Loop, and Sequence

• Able to connect to various data source types in SSIS

• Know how to schedule a job in SSIS

• Able to call a stored procedure in SSIS

• Able to find the top 3rd salary in SQL

• Understand the difference between Delete and Truncate statements in SQL

• Familiar with Clu...read more

Yes, I have implemented logging in my projects.

• I use log4net library for logging.

• I log all the important events and errors in the application.

• I store the logs in a separate file or database table.

• I also use different log levels to differentiate between different types of logs.

• I regularly review the logs to identify any issues or areas of improvement.

Yes, I have done performance tuning in SSIS.

• Identify bottlenecks using performance counters and logging

• Optimize data flow by using appropriate transformations and buffer sizes

• Use parallelism and concurrency to improve performance

• Minimize network traffic by compressing data and using bulk load operations

• Use caching and lookup transformations to reduce database queries

• Profile and test the package to validate performance improvements

Control flow and data flow are two important components of SSIS. There are various types of transformations available in SSIS.

• Control flow is used to manage the flow of tasks and containers in a package.

• Data flow is used to extract, transform, and load data from various sources to destinations.

• Transformations are used to modify data during the ETL process. There are various types of transformations such as Aggregate, Derived Column, Lookup, Merge, etc.