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 implement a SQL Server 2008 Integration Services (SSIS) package. The package contains the components below:

A String variable named FileName.
A String variable named DirectoryPath.

A Foreach Loop container for the Collection property as shown in the following exhibit. (Click the Exhibit button.)
A Foreach Loop container for the Variable Mappings property as shown in the following exhibit. (Click the Exhibit button.)

In order to make the DirectoryPath variable return the directory path for the file path stored in the FileName variable, you have to update the package.
What should you do? (choose more than one)

A.
The RaiseChangedEvent property of the User::FileName variable should be set to True

B.
A Script task should be added to the OnPostExecute event handler of the Foreach Loop container

C.
The EvaluateAsExpression property of the User::DirectoryPath variable should be set to True

D.
The Expression property of the User::FileName variable should be set to the following expression. SUBSTRING( @[User::FileName], 1, LEN( @[User::FileName] ) – FINDSTRING( REVERSE( @[User::FileName] ), “\”, 1 ))

E.
The Expression property of the User::DirectoryPath variable should be set to the following expression. SUBSTRING( @[User::FileName], 1, LEN( @[User::FileName] ) – FINDSTRING( REVERSE( @[User::FileName] ), “\”, 1 ))