How to set value of variable from script task for data flow task

Question

I am new to SSIS and creating package for IDL (incremental data load) for multiple tables.

My package has Execute SQL TASK and it is working when I set value of variable from script task But when I try to set value of variable from script task for data flow (oldedb source ) It is not working e.g

My SSIS package:

• Foreachloop container

• Script task to loop through schema for table and set SourceTable=TableName.

• oledb source (use SourceTable)
• lookup (Lookup no match out put)
• Oldedb destination

Any idea why??

Update:

Answer 1

SSIS reports such exotic error from Data Source Component when it is unable to extract metadata information (column names and data types) from the source specified. Below are possible cases and ToDos:

• Data Source is validated before package run, at this time no value at SourceTable variable exists. ToDo - specify DelayValidation=true for DataFlow task, or set some valid default value (pointing to table existing at start time) for the SourceTable variable
• SourceVariable contains invalid table name at run time. This happens if you made changes described above and the error persists. Use the debugger to inspect its value and analyze the case.