Re: Simple Bulk Insert

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Wayne Snyder (wayne.nospam.snyder_at_mariner-usa.com)
Date: 09/20/04 

Date: Mon, 20 Sep 2004 08:04:25 -0400

That's a neat thing Uri, I have never tried a multi-character field
terminator... But would it work on the FIrst and last field? If the
terminator is "," 

-- 
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Prabhat" <not_a_mail@hotmail.com> wrote in message
news:%23z6uOYwnEHA.1152@TK2MSFTNGP10.phx.gbl...
> Hi All,
>
> I have one TEXT (Source file = D:\V090804.TXT) file which I want to Bulk
> Insert into SQL Table (Table Name =  PLEDGEFILE) of Same Structure.
>
> The text file has Data like:
>
> "I","0406927277","MR","EUGENE","JUNGBLUTH"
> "I","0401111111","MRS","PAULA","DICESARE"
>
> and My Bulk Insert Statement like:
>
> BULK INSERT PLEDGEFILE FROM 'D:\V090804.TXT'
>         WITH (FIRSTROW = 1, FIELDTERMINATOR = ',', ROWTERMINATOR = '\n')
>
> But this is Not working. I think it is treating "I" as value for 1st
Column
> [Including "" = Double Quotes.] while My field length is 1 for 1st column.
I
> Don't want the Double Quotes. I want Only the VALUE.
>
> Please Suggest How do I Bulk Insert Only Values - Excluding the double
> Quotes.
>
> Thanks
> Prabhat
>
>
>
>

Relevant Pages

  • Re: Simple Bulk Insert
    ... I have never tried a multi-character field ... terminator is "," ... Wayne Snyder, MCDBA, SQL Server MVP ... > and My Bulk Insert Statement like: ...
    (microsoft.public.sqlserver.programming)
  • Re: Generating one table with a terabyte of data
    ... Pretty much disabled the transaction log completely. ... We are using BULK INSERT ... for all those who don't know, SQL server prefers smaller BULK ... ORACLE seems to handle that 1 big file really well but with small files SQL ...
    (microsoft.public.sqlserver.dts)
  • Re: Recordset.AddNew and the recordset objects data retaining
    ... I am in an environment where bulk insert isn't an option--even though the ... underlying database is SQL server, I am using a third party OLE DB provider-- ... > insert(assuming you are using SQL server) or DTS. ...
    (microsoft.public.data.ado)
  • Re: Can Indexes effect Bulk Insert/Update Operations
    ... Columnist, SQL Server Professional ... becuase some operations need to be performed before insert/update the ... "Tom Moreau" wrote in message ... > unique/pk constraints before bulk loading the tables. ...
    (microsoft.public.sqlserver.programming)
  • Re: Timeout Expired
    ... So the timeout occurs during the bulk load operations? ... did you check the SQL Error Logs to see more clues about the timeout problem if there is any? ... locked for DML operations by SQL Server. ...
    (microsoft.public.sqlserver.server)