Matching
Matching :
Premises:
tasks that perform operations on schema objects and data on a SQL server
a storage unit within an SSIS package that can hold both static values or whose values can be set at run time
a text file that contains data
tasks that move data between a source and a destination
the order in which each task in an SSIS package is executed
tasks that perform essential database maintenance functions
tasks that permit an SSIS package to interact with other applications
a stand-alone application that is run from a command prompt and that can be used for bidirectional data transfer
an object within an SSIS package that stores the configuration information necessary to connect to an individual data source
a collection of one or more tasks grouped together as a series of logical steps
Responses:
data flow tasks
control flow
maintenance tasks
workflow tasks
user variable
connection manager
SQL Server tasks
bcp utility
SSIS package
flat file
Correct Answer:
Premises:
Responses:
tasks that perform operations on schema objects and data on a SQL server
a storage unit within an SSIS package that can hold both static values or whose values can be set at run time
a text file that contains data
tasks that move data between a source and a destination
the order in which each task in an SSIS package is executed
tasks that perform essential database maintenance functions
tasks that permit an SSIS package to interact with other applications
a stand-alone application that is run from a command prompt and that can be used for bidirectional data transfer
an object within an SSIS package that stores the configuration information necessary to connect to an individual data source
a collection of one or more tasks grouped together as a series of logical steps
Premises:
tasks that perform operations on schema objects and data on a SQL server
a storage unit within an SSIS package that can hold both static values or whose values can be set at run time
a text file that contains data
tasks that move data between a source and a destination
the order in which each task in an SSIS package is executed
tasks that perform essential database maintenance functions
tasks that permit an SSIS package to interact with other applications
a stand-alone application that is run from a command prompt and that can be used for bidirectional data transfer
an object within an SSIS package that stores the configuration information necessary to connect to an individual data source
a collection of one or more tasks grouped together as a series of logical steps
Responses:
Related Questions
Q25: What is control flow and how can
Q26: What are two methods you can use
Q27: _ tasks allow custom code to be
Q28: Why would you use a format file
Q29: An application programming _ defines the communication
Q31: What should you use when running the
Q32: SSIS is a component of SQL Server
Q33: Describe the SQL Server Import and Export
Q34: An SSIS _ groups together a set
Q35: How does SQL Server 2012 support ODBC
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents