Professional Web Applications Themes

Bulk Insert Error - Microsoft SQL / MS SQL Server

What error? Some code snippets may help. -- Hope this helps. Dan Guzman SQL Server MVP ----------------------- SQL FAQ links (courtesy Neil Pike): http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800 http://www.sqlserverfaq.com http://www.mssqlserver.com/faq ----------------------- "LIN" <com> wrote in message news:phx.gbl...  I am  the ...

  1. #1

    Default Re: Bulk Insert Error

    What error? Some code snippets may help.

    --
    Hope this helps.

    Dan Guzman
    SQL Server MVP

    -----------------------
    SQL FAQ links (courtesy Neil Pike):

    http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
    http://www.sqlserverfaq.com
    http://www.mssqlserver.com/faq
    -----------------------

    "LIN" <com> wrote in message
    news:phx.gbl... 
    I am 
    the 


    Dan Guest

  2. #2

    Default Re: Bulk Insert Error

    You might try iterating over the errors collection in a Try/Catch block
    so that you can selectively ignore certain errors. For example:

    Try
    command.ExecuteNonQuery()
    Catch ex As SqlException
    For Each sqlError As SqlError In ex.Errors
    If (sqlError.Number = 4864) Then
    'ignore "Bulk insert data conversion error"
    Else
    Trace.WriteLine(ex.ToString())
    Environment.ExitCode = 1
    End If
    Next sqlError
    End Try

    --
    Hope this helps.

    Dan Guzman
    SQL Server MVP

    -----------------------
    SQL FAQ links (courtesy Neil Pike):

    http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
    http://www.sqlserverfaq.com
    http://www.mssqlserver.com/faq
    -----------------------

    "LIN" <com> wrote in message
    news:%phx.gbl... 
    the text 
    error 
    writing 
    to [/ref][/ref]
    when [/ref][/ref]
    though 
    > >
    > >[/ref]
    >
    >[/ref]


    Dan Guest

  3. #3

    Default Re: Bulk Insert Error

    thanks a ton. i'll try it out.

    Thanks again.

    LIN


    "Dan Guzman" <net> wrote in message
    news:phx.gbl... 
    > the text 
    > error 
    > writing 
    > to [/ref]
    > when [/ref]
    > though 
    > >
    > >[/ref]
    >
    >[/ref]


    LIN Guest

Similar Threads

  1. BULK INSERT
    By sampsas23 in forum Coldfusion - Getting Started
    Replies: 10
    Last Post: January 12th, 01:50 PM
  2. Bulk Insert
    By Mirza in forum Microsoft SQL / MS SQL Server
    Replies: 5
    Last Post: August 8th, 12:25 PM
  3. more description of why i need bulk insert command for vb?
    By Trint in forum Microsoft SQL / MS SQL Server
    Replies: 5
    Last Post: August 6th, 01:03 AM
  4. bulk insert command for vb?
    By Trint in forum Microsoft SQL / MS SQL Server
    Replies: 2
    Last Post: August 5th, 03:42 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139