Facing a the same issue almost .

BackGround:A job runs every month to load an excel file to SQL Server.The Excel file differs Month to Month and hence cannot be imported to a specific pre-existing table.

What I am Trying to Do:

1.Created a variable [User::TableName] which will hold the name of the new destination table. This table name will be decided by another application.

2.Created a Excel Data Source to import the excel data

3.Created a OLE DB Destination for the data.

Question:

1.How do i use this variable [User::TableName] to assign the name of

the new table that is going to be created?

2.How to configure the package so that it creates a new table everytime it runs using [User::TableName] as the table name?

Stuck with this for a long time .Please help!!!