|
arkiboys
Flowing Fount of Yak Knowledge
1341 Posts |
 Posted - 07/07/2011 : 04:09:32
|
in control flow, using execute sql task, I have created a global table with delay validation set to thrue and connection set to retainsameconnection.
In the oledbsource inside dataflow, I would like to access this global table but when I choose the sqlcommand inside the oledbsource and place the query such as select * from ##tbl1 then it gives an error: invalid object name ##tbl1
Do you know the issue here please?
Thanks |
|
temp table
