Hi,

I little change sample, so I use this variables:

1)

FilePath='c:\temp\sample.xls'

(but, I can dynamicly create file name through expression properties, like

"c:\\temp\\test_" + substring((DT_STR, 50,1250) GETDATE(),1,10)+".xls"

if I need file name

c:\temp\test_2008-01-10.xls

EvaluateAsExpression property needs to be 'True'

2)

In Excel connection manager in Expression Property I set 'excelFilePath' to @[User::FilePath]

3)

ExcelTab Variable is set throuh Expression to

(EvaluateAsExpression property needs to be 'True')

"CREATE TABLE `" + @[User::region] + "` (

`my_field` VARCHAR(50)

)"

4) In Execute SQL Task, I Set

Connection Type to 'Excel'

Connection to existing Excel connection manager (created in step 2)

SQl source type to 'Variable'

SourceVariable to 'User::ExcelTab' (created in step 3)

Execute workws perfectly if excel file with @[User::region] doesn't exists.

It will fail if it exists.

radovan