Professional Web Applications Themes

EOF error in BCP - Microsoft SQL / MS SQL Server

hey all, does any one know an effective way to "Error Handle" an 'unexpected End Of File' in BCP using Tsql ? it doesn't seem to return a error code and I'm not familiar with a way to catch the SQL state return code. I prefer not using Bulk Insert in this case. anybody ?...

  1. #1

    Default EOF error in BCP

    hey all,

    does any one know an effective way to "Error Handle"
    an 'unexpected End Of File' in BCP using Tsql ?
    it doesn't seem to return a error code and I'm not
    familiar with a way to catch the SQL state return code.
    I prefer not using Bulk Insert in this case.
    anybody ?
    Jon Gudman Guest

  2. #2

    Default Re: EOF error in BCP

    [posted and mailed, please reply in news]

    Jon Gudman (Yair_g80hotmail.com) writes:
    > does any one know an effective way to "Error Handle"
    > an 'unexpected End Of File' in BCP using Tsql ?
    > it doesn't seem to return a error code and I'm not
    > familiar with a way to catch the SQL state return code.
    > I prefer not using Bulk Insert in this case.
    > anybody ?
    I will have to assume that you invoke BCP through xp_cmdshell. You
    can check the return value from xp_cmdshell; this is the return value
    from DOS level. I seem to recall that BCP sets an error code in all
    situations, but I don't think unexpected end of file is one of them.

    You can also say

    INSERT #temp (data)
    EXEC master..xp_cmdshell bcpcmd

    This will give you all output from xp_cmdshell in the temptable,
    which you then can yse.



    --
    Erland Sommarskog, SQL Server MVP, [email]sommaralgonet.se[/email]

    Books Online for SQL Server SP3 at
    [url]http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp[/url]
    Erland Sommarskog Guest

Similar Threads

  1. Replies: 0
    Last Post: March 29th, 09:49 PM
  2. Replies: 0
    Last Post: November 10th, 05:24 PM
  3. Postscript Print error (ERROR: rangecheck; OFFENDING COMMAND: filter)
    By Darrell_J_Brown@adobeforums.com in forum Adobe Acrobat Windows
    Replies: 1
    Last Post: May 13th, 11:24 AM
  4. Replies: 0
    Last Post: September 25th, 03:23 AM
  5. Replies: 1
    Last Post: August 7th, 07:13 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