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...

________ type(s) of hyperlinks link the audience to Internet resources

A) One B) Two C) Three D) Four

Computer Science & Information Technology

Adjustments in the UAC control settings range from Never notify to ________ notify

Fill in the blank(s) with correct word

Computer Science & Information Technology

How do you create a unique header or footer for one part of a document?

What will be an ideal response?

Computer Science & Information Technology

In the Move dialog box, you can enter a value for the angle you want to move an object.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology