Re: Temporal tables

#1

You can use global temporary tables(##table) , which can be available to all
the users. Check BOL for more details.

HTH
Praveen Maddali

"Justing Xiang" <gufix (AT) navegalia (DOT) com> wrote

Quote:

Hi, everybody,
Is there any way to create temporal tables (#table) and make them
visible within any task in a dts?
Thanks,
Justingx

#2

Hi,
Remember temp tables are only temporary and it will desapear after run.
Good idea is to create a phisical table and drop the table at the end or
after finish you process.
DROP TABLE tablename
JFB

"Justing Xiang" <gufix (AT) navegalia (DOT) com> wrote

Quote:

Hi, everybody,
Is there any way to create temporal tables (#table) and make them
visible within any task in a dts?
Thanks,
Justingx

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Temporal tables

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: Temporal tables - 07-17-2003 , 03:52 AM

Re: Temporal tables - 07-17-2003 , 03:25 PM