bcp or bulkinsert

hi
what are the differences between
bcp and bulk insert?
Thanks
ICHORHi,
BCP.EXE is a client application (even when run on the server), so it uses an
ODBC client connection, goes through Net-Library
and ODS on the server side before the rowset gets inserted in the server.
BULK INSERT is completely server side and reads the source file directly
into a rowset so it can be inserted in the database, so no client
connection, it bypasses the network (NetLibrary) and client handler (ODS) of
SQL Server.
Thanks
Hari
SQL Server MVP
"ichor" <ichor@.hotmail.com> wrote in message
news:eZLYQRBaFHA.612@.TK2MSFTNGP12.phx.gbl...
> hi
> what are the differences between
> bcp and bulk insert?
> Thanks
> ICHOR
>|||The major difference between bcp and BULK INSERT is that BULK INSERT cannot
export data whereas BCP can. Also BCP is a command line utility so you have
to use XP_CMDSHELL to use BCP and with BULK INSERT you can run in your scrip
t
window without having to drop out to command line. BULK INSERT allows you t
o
use a FORMAT file to tell process how to handle the data that is coming into
you table and you can use BCP FORMAT to create a format file to use with you
r
BULK INSERT statement.
Also BCP is a command line utillity
Below is an example of simple usage of BCP and BULK INSERT.
/* Get Details about BCP usage */
Create Table #BCP
(
info nvarchar (255)
)
Insert #BCP
EXEC xp_cmdshell 'BCP '
Select * from #BCP
Drop table #BCP
/*Bulk Insert Example */
BULK INSERT [dbo].[hard_drives]
FROM 'C:\hard_drives.txt'
WITH
(
DATAFILETYPE = 'char',
FIELDTERMINATOR = ',',
FIRSTROW = 2,
ROWTERMINATOR = '\n'
)
Hope this helps.
"ichor" wrote:

> hi
> what are the differences between
> bcp and bulk insert?
> Thanks
> ICHOR
>
>

basic vs. advance

Hi,
Does anyone knows the differences or if there is a document available
explaining the differences between the following under SQL 2005 server:
Basic ETL and Advance ETL
Standard OLAP and Advance OLAP
Standard Reporting and Advance Reporting
Thanks
Mark
I'm interested in knowing too...
burt_king@.yahoo.com
"Mark" wrote:

> Hi,
> Does anyone knows the differences or if there is a document available
> explaining the differences between the following under SQL 2005 server:
> Basic ETL and Advance ETL
> Standard OLAP and Advance OLAP
> Standard Reporting and Advance Reporting
>
> Thanks
> Mark
>
>
>
>

basic vs. advance

Hi,
Does anyone knows the differences or if there is a document available
explaining the differences between the following under SQL 2005 server:
Basic ETL and Advance ETL
Standard OLAP and Advance OLAP
Standard Reporting and Advance Reporting
Thanks
MarkI'm interested in knowing too...
--
burt_king@.yahoo.com
"Mark" wrote:

> Hi,
> Does anyone knows the differences or if there is a document available
> explaining the differences between the following under SQL 2005 server:
> Basic ETL and Advance ETL
> Standard OLAP and Advance OLAP
> Standard Reporting and Advance Reporting
>
> Thanks
> Mark
>
>
>
>

basic vs. advance

Hi,
Does anyone knows the differences or if there is a document available
explaining the differences between the following under SQL 2005 server:
Basic ETL and Advance ETL
Standard OLAP and Advance OLAP
Standard Reporting and Advance Reporting
Thanks
MarkI'm interested in knowing too...
--
burt_king@.yahoo.com
"Mark" wrote:
> Hi,
> Does anyone knows the differences or if there is a document available
> explaining the differences between the following under SQL 2005 server:
> Basic ETL and Advance ETL
> Standard OLAP and Advance OLAP
> Standard Reporting and Advance Reporting
>
> Thanks
> Mark
>
>
>
>

Basic VS Advanced Integration Services

Where can I get a good list of what the exact differences are between the Basic and the Advanced version of SQL Server Integration Services are? I have been looking and looking online. But I don't see much of anything written on this issue online. Please help!

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

-Jamie

|||I have seen this link. But that doesn't give me a good comparison between the Basic and the Enterprise editions of SQL Server Integration Services. Thanks
|||

Yes it does (assuming that by "Basic" you mean "Standard". There is no "Basic" edition).

At the bottom of that page you'll see "SQL Server Integration Services Data Flow Integration" and "Text Mining" with a tick in the "Enterprise" column. That's the difference between Enterprise and other editions. There is nothing else. Note that these include Fuzzy operations.

-Jamie