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 |
|
Avdhut
Starting Member
11 Posts |
 Posted - 2012-03-13 : 06:06:49
|
| Hi,I am using Execute SQL Task to create a temporary tables.Then I am using Sequence container,in that i have used severals Execute SQL Task, in which i had used that Temporary table. But the Error occured that invalid object name i.e the temp table is not accessible. I have set the retainconection property of Connection manager as "True" and also Delay Validation = "True". But still the errors come. Please give the correct answer for this. Thanks in advance. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
|
|
|
|
|
Using Temporary Tables in SSIS 2008