December 10, 2009 at 11:18 am
Can we see temp table in the drop down to select a destination table
from a data flow task?
I went through a lot of articles and forums but nothing seems to be working.
Please help.
Thanks.
December 10, 2009 at 11:38 am
Surely if it's temporary, it will not exist at design time and therefore how could SQL Server know about it?
What are you hoping to use the temp table for?
December 10, 2009 at 1:48 pm
Just Learning.
I tought it is not possible untill i saw a article and a forum in MSDN and ended up no where.
December 10, 2009 at 8:24 pm
The short answer is no. As Phil wrote, you will in most cases be using a different connection during runtime, and any temporary object created under a different connection would not be visible or accessible at runtime.
If you're doing this for training or demonstration purposes, I suggest creating a test database, or one or more test tables in an existing database.
hth,
Tim
Tim Mitchell
TimMitchell.net | @tmitch.net | Tyleris.com
ETL Best Practices
December 11, 2009 at 9:30 am
[font="Comic Sans MS"]
Not talking about best practise or business requirement - but just in case - say "Learning Purpose" - if someone need to use temporarily table - there are ways. Not exactly how the original question was posted - but if the a temporary table using an was create by say - Execute SQL Task and then consume it using an OLE DB Source component in a data-flow task.
As usual - a nice article from Jamie Thomson.
[/font]
[font="Comic Sans MS"]--
Sabya[/font]
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply