Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2011-07-07 : 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 ##tbl1Do you know the issue here please?Thanks |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-07-07 : 04:40:08
|
| Think it's because it needs to get a design time structure.Try creating the table while you develop the package but delete it to run.Might be easier to cretae the table then call another package to access it.Any reason why you can't have a permanent table which you truncate?==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2011-07-07 : 05:06:55
|
| solved. thanks |
|
|
|
|
|
|
temp table