Is there sth like Direct-Path-Loads in SQL-Server

I'm familiar with direct-path-loads and SQL*Loader on Oracle.
Does anyone know if sth like this is available on SQL-Server?
Sounds like you are looking for tools that support bulk loading (a more direct way to import data
than INSERT statements). Such tools include BULK INSERT, BCP.EXE. Also DTS (2000) or SSIS (2005) if
you select the option to do "fast load".
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Franz Gross" <Franz.Gross@.gmx.li> wrote in message
news:46467d32$0$23139$9b4e6d93@.newsspool1.arcor-online.net...
> I'm familiar with direct-path-loads and SQL*Loader on Oracle.
> Does anyone know if sth like this is available on SQL-Server?
|||Hi Franz
"Franz Gross" wrote:

> I'm familiar with direct-path-loads and SQL*Loader on Oracle.
> Does anyone know if sth like this is available on SQL-Server?
>
Tibor replied to this in microsoft.public.sqlserver.datawarehouse please do
not multipost.
John
|||John Bell (jbellnewsposts@.hotmail.com) writes:
> "Franz Gross" wrote:
>
> Tibor replied to this in microsoft.public.sqlserver.datawarehouse please
> do not multipost.
Actually, Franz did have the good taste to cross-post. And set followup
to the group that possibly was the most relevant. (Pity that Tibor
respected that. Now I still don't know what a direct-load-path might be.)
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
|||My bad, I should have read the header closer and not assumed that Tibor's
reply
not being in .server was the OP's error!
AFAIK direct path load is a method of loading data with minimal
checking/processing and therefore faster.
John
"Erland Sommarskog" wrote:

> John Bell (jbellnewsposts@.hotmail.com) writes:
> Actually, Franz did have the good taste to cross-post. And set followup
> to the group that possibly was the most relevant. (Pity that Tibor
> respected that. Now I still don't know what a direct-load-path might be.)
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>
|||On 14.05.2007 10:12, John Bell wrote:
> My bad, I should have read the header closer and not assumed that Tibor's
> reply
> not being in .server was the OP's error!
> AFAIK direct path load is a method of loading data with minimal
> checking/processing and therefore faster.
Correct. You may even end up with defunct unique indexes if the data is
not unique. AFAIK there is no such thing in SQL Server.
Kind regards
robert