What are SSIS packages, how are they stored, and what are their basic building blocks?

What will be an ideal response?

An SSIS package groups together a set of one or more tasks - as a series of logical steps - into a single object that can be executed using the SQL Server Integration Services service. A package is stored with a .dtsx file extension irrespective of the method used to create it. The basic building blocks within an SSIS package are known as tasks, each of which performs a specific activity or function.

Computer Science & Information Technology

You might also like to view...

Draw a picture of a point-to-point wireless connection.

What will be an ideal response?

Computer Science & Information Technology

A class’s methods are often referred to as ______ in other object-oriented program- ming languages.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology