SSIS Set Destination Table Name

I have an SSIS Package that needs to load data through an oledb component into a table whose name is not known until runtime. In the oledb destination editor I have selected "Data access mode" as "Table name or view name variable". I have entered my "Variable name" that holds the name of the table. When I hit the preview button I am presented with a preview of the correct table. However, when I attempt to run / debug the package I get the following message at the validation stage - before the package even attempts to run:

Information: 0x4004300A at Check Recs and Insert, DTS.Pipeline: Validation phase is beginning.

Error: 0xC0202042 at Check Recs and Insert, Insert Into TransactionX table [2269]: A destination table name has not been provided.
Error: 0xC004706B at Check Recs and Insert, DTS.Pipeline: "component "Insert Into TransactionX table" (2269)" failed validation and returned validation status "VS_ISBROKEN".
Error: 0xC004700C at Check Recs and Insert, DTS.Pipeline: One or more component failed validation.
Error: 0xC0024107 at Check Recs and Insert: Th开发者_StackOverflow中文版ere were errors during task validation.
SSIS package "PointsPartnerImport.dtsx" finished: Failure.

It says A destination table name has not been provided. but it has! Has anyone had a similar problem?

What programmatic format are the data in? I had a similar problem today trying to import data from an Excel spreadsheet. It turned out that the spreadsheet's name had a " " (physical white space) in it. SSIS wasn't too happy about that. But for whatever reason, the problem resolved itself after I replaced that white space with an _ (underscore).

As to why, my guess is certain characters should generally be avoided in titles such as white spaces or hyphens. There may be characters in addition to the white space that give a similar error (hyphens?).

Are u setting the variable to a default value? Check this article out: msdn thread

1. Make sure the Variable name has a default value and it matches the first sheet name in your Excel workbook. SSIS needs to load the first worksheet during design time, you cannot skip this validation.
2. Spaces or special characters in the Sheet name will not affect the functionality.