You are a database developer and you have about two years experience in creating business Intelligence (BI) by using SQL Server2008.
Now you are employed in a company named NaproStar which uses SQL Server2008. You work as the technical support.
You make modification on a SQL Server 2008 Integration Services (SSIS) package. Look at the following SQL Server 2008 table.
The package loads the data extracted from a text file to this table.
Now you receive an order from your company CIO, the package has to be updated to extract data from multiple text files of the same directory.
In order to achieve this goal, what should you do? (choose more than one) (Exhibit)
A.
An expression should be added to the Flat File connection manager
B.
A variable should be added to the package
C.
A For Loop container should be added to the package
D.
A variable should be added to the data flow task
E.
Ad Foreach Loop container should be added to the package
F.
An expression should be added to the Flat File Source component