You are designing a SQL Server Integration Services(SSIS) package configuration strategy.
The package configuration must meet the following requirements:
Include multiple properties in a configuration.
Force packages to load all settings in the configuration.
Support Encrypting File System (EFS) formats.
You need to select the appropriate configuration.
Which configuration type should you use?
To answer, select the appropriate option from the drop-down list in the dialog box.
Hot Area:
Answer:
Explanation:
SQL Server
0
0
XML Configuration File
0
0
indeed xml
0
0
XML Configuration File, “Support Encrypting File System (EFS) formats”
0
0
The sales database includes a table named Customers that contains 45 columns and two tables that record all sales. The database does not store aggregated sales data. The database is continually maintained to provide optimal indexing. The database server is sized appropriately. The marketing department requests a delimited text file that includes six fields containing customer demographic information from the Customer table. You have the following requirenments
• Display the CustomerID in the first column. Organize the remaining columns alphaetically by column heading
• Sort Rows in Customer ID order
• Aggregate gross annual sales
• Minimize the time required to return the result
A -Only a SQL command -based and a Flat file destination
B – A table -based OLE DB Source, a script component and a Flat file destination
C – A SQL command -based OLE DB Source Aggregate and Sort Transformations and a Flat file destination
D – A table -based OLE DB Source Lookup, Aggregate and Sort Transformations and a Flat file
Can anyone help me resolve this question ?
0
0