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.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Staging Table

Author  Topic 

ansz5
Starting Member

4 Posts

Posted - 2009-03-20 : 02:56:17
What is a staging table ?

How to use it ?
And when is it advised to use a staging table - When transferring data from 1 server to another .. or when there are 2 diffrent databases but on the same server.

Pls advise.

Thanks

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-05-12 : 10:18:38
A staging table (or complete area) is often used to scrub or cleans data when importing.
It can also be used for integrity checks.


E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page
   

- Advertisement -