June 27, 2006 at 4:34 pm
My goal is to retrieve remote SQL server data and consolidate it to a central location for ease of use. I primarily use system stored procedures and insert the results into a temp table. My problem is that within DTS, you can't run Data Transform Tasks against temp tables. I'm thinking I'll just create permanent tables in tempdb, then drop them after I'm done. Anyone know of any caveats with this method? Security? Is there more overhead behind temp tables vs permanent ones?
thanks!
June 28, 2006 at 1:00 am
you can also use ##-temptables (#-temptb = local temp tb, ##-temptb = global temp tb).
You can create normal tables in tempdb, but I wouldn't advise to use it because when sqlserver is stoped and started again, tempdb is cleared / initialized !
Maybe havening you own small db for this purpose is the best solution.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply