Recent questions and answers in SSIS Interview Questions and Answers

Recent questions and answers in SSIS Interview Questions and Answers

Nice?Vote!

Add
Ans!

why we use execute sql task

asked 3 weeks ago by anonymous

Nice?Vote!

1 answer

What are the points to keep in mind for performance improvement of the package?

answered 10 months ago by anonymous

Nice?Vote!

1 answer

Difference between DTS and SSIS?

answered 1 year ago by anonymous

Nice?Vote!

1 answer

Type your question here! No need to register!

answered 1 year ago by anonymous

Nice?Vote!

2 answers

What is a breakpoint in SSIS? How is it setup? How do you disable it?

answered 1 year ago by Anand (1,440 points)

Nice?Vote!

2 answers

Can you explain how to deploy an SSIS package?

answered 1 year ago by Anand (1,440 points)

Nice?Vote!

1 answer

How do you schedule ssis packages to run on the fly?

answered 1 year ago by anonymous

Nice?Vote!

1 answer

Will trigger fire when inserting data through SSIS package?

answered 1 year ago by R (19,530 points)

Nice?Vote!

3 answers

How would you do Error Handling?

answered 1 year ago by GabrieFinch (220 points)

Nice?Vote!

1 answer

Name the three main tabs in the Visual Studio interface for SSIS Packages and the associated purpose.

answered 1 year ago by R (19,530 points)

Nice?Vote!

1 answer

What is the dtutil and name some of the functionality it provides?

answered 1 year ago by R (19,530 points)

Nice?Vote!

1 answer

What are the different options to execute an SSIS Package?

answered 1 year ago by R (19,530 points)

Nice?Vote!

1 answer

Whiteboard techniques you would use to for CDC (Change Data Capture)?

answered 1 year ago by R (19,530 points)

Nice?Vote!

1 answer

Explain what breakpoints are and how you would use them

answered 1 year ago by R (19,530 points)

Nice?Vote!

3 answers

Various SSIS Data Flow Components?

answered 1 year ago by R (19,530 points)

+1 vote

1 answer

Various Control Flow Items in SSIS?

answered 1 year ago by R (19,530 points)

Nice?Vote!

1 answer

Define SSIS Data Flow Task

answered 1 year ago by R (19,530 points)

Nice?Vote!

1 answer

Whar are the Two Categories of Control Flow tasks?

answered 1 year ago by anonymous

Nice?Vote!

1 answer

How to unzip a File in SSIS?

answered 1 year ago by R (19,530 points)

Nice?Vote!

1 answer

Lookup's are a key component in SQL Server Integration Services (SSIS). Explain its purpose

answered 1 year ago by R (19,530 points)

To see more, click for all the questions in this category.