I have a execute sql task which will create the temp table and below to this task I have a DataFlowTask which will insert data into the Temporary table.
Here I am facing one issue,even though the temporary table is getting created I am getting one error .Invalid Object name '##TempTable".
WHy this is Happening.
I have set the conncetion manager RetainSameConnection property to true.I have set the delay validation property of dataflow to True.
Still the error is coming.
Please help me.
View Complete Post