You are creating a SQL Server 2008 Integration Services (SSIS) instance which includes
components listed below for Company.com.
A String variable called FileTestName.
A String variable called DirectoryTestPath.
A Foreach Loop container for the Collection property is listed below:
A Foreach Loop container for the Variable Mappings property is listed below: In order to
update the package so that the DirectoryTestPath variable gets the directory path for the file
path reserved in the FileTestName variable.
Which is the correct answer? (Select two)
A.
You should configure the EvaluateAsExpression attribute of the User::DirectoryPath
parameter to False.
B.
You should configure the EvaluateAsExpression attribute of the User::DirectoryPath
parameter to True.
C.
You should increase a Script job to the OnPostExecute event handler of the Foreach
Loop container.
D.
You should configure the Expression property of the User::DirectoryPath parameter to the
following expression. SUBSTRING( @[User::FileName], 1, LEN( @[User::FileName] ) –
FINDSTRING( REVERSE( @ [User::FileName] ), “\\”, 1 ))
E.
You should configure the Expression property of the User::DirectoryPath parameter to the
following expression. SUBSTRING( @[User::FileName], 10 LEN( @[User::FileName] ) –
FINDSTRING( REVERSE( @ [User::FileName] ), “\\”, 0))