SSIS Set Detination Table Name

Question

I have a SSIS Package that needs to load data throught 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 present 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: There 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?

Many thanks,

Rob.

Answer 1

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