Professional Web Applications Themes

more description of why i need bulk insert command for vb? - Microsoft SQL / MS SQL Server

ok, i have these files needing to go into these tables in sql server 2000: Program.txt = TBL_Client BatchGroup.txt = TBL_Group Catalog.txt = TBL_Catalog Item.txt = TBL_MasterItem ItemSold.txt = TBL_ItemsSold Seller.txt = TBL_Seller they will always have the same format...something like this: "HSHS02","M100011","000289000","1106","3","" "HSHS02","M100011","000289000","1140","3","" "HSHS02","M100016","000289000","1143","1","" "HSHS02","M100011","000289000","1509","3","" i still don't understand if bulk insert is a command for vb.net or what. help! thanks, Trint .Net programmer com *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!...

  1. #1

    Default more description of why i need bulk insert command for vb?

    ok,

    i have these files needing to go into these tables in sql server 2000:

    Program.txt = TBL_Client
    BatchGroup.txt = TBL_Group
    Catalog.txt = TBL_Catalog
    Item.txt = TBL_MasterItem
    ItemSold.txt = TBL_ItemsSold
    Seller.txt = TBL_Seller

    they will always have the same format...something like this:

    "HSHS02","M100011","000289000","1106","3",""
    "HSHS02","M100011","000289000","1140","3",""
    "HSHS02","M100016","000289000","1143","1",""
    "HSHS02","M100011","000289000","1509","3",""

    i still don't understand if bulk insert is a command for vb.net or what.
    help!
    thanks,
    Trint


    .Net programmer
    com

    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!
    Trint Guest

  2. #2

    Default more description of why i need bulk insert command for vb?

    Take a look at DTS do to that. If you only have 6 files,
    you can probably get it all done in about 30 mins.

     
    server 2000: 
    this: 
    vb.net or what. 
    *** 
    Steve Guest

  3. #3

    Default Re: more description of why i need bulk insert command for vb?

    "bulk insert" is a server command (i.e. it runs on the server). That means
    your data file (txt) must reside somewhere that the servers can get to.

    As far as your data, you would need to use a format file to help 'bulk
    insert' import it correctly. Here is an example of using a format file with
    bcp. Please take a look at "bcp" or "bulk insert" in sql book online for
    much info.

    http://makeashorterlink.com/?Y2C053D75
    http://makeashorterlink.com/?A12122D75

    http://msdn.microsoft.com/library/en-us/adminsql/ad_impt_bcp_9yat.asp?frame=
    true
    --
    -oj
    RAC v2.2 & QALite!
    http://www.rac4sql.net


    "Trint Smith" <com> wrote in message
    news:#phx.gbl... 


    oj Guest

  4. #4

    Default Re: more description of why i need bulk insert command for vb?

    Thanks, but this must be implemented by the program...the company will
    use this via a button about 12 times a day

    ..Net programmer
    com

    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!
    Trint Guest

  5. #5

    Default Re: more description of why i need bulk insert command for vb?

    You can write a VB program to call the DTS job and execute it. Look at the
    DTS samples that come with SQL Server
    "Trint Smith" <com> wrote in message
    news:phx.gbl... 


    Partha Guest

  6. #6

    Default Re: more description of why i need bulk insert command for vb?

    On Mon, 04 Aug 2003 11:36:27 -0700, Trint Smith <com>
    wrote:
     

    DTS is a set of COM objects. You can install them on your client PC
    without installing SQL Server client on it, as long as you have MDAC
    (ADO/OLE-DB etc).

    Take a look at this web site for more info:

    www.sqldts.com

    The procedure for installing DTS with your application is here:

    http://www.sqldts.com/default.aspx?6,105,225,0,1

    cheers,
    Ross.
    --
    Ross McKay, WebAware Pty Ltd
    "Since when were you so generously inarticulate?" - Elvis Costello

    Ross 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. bulk insert command for vb?
    By Trint in forum Microsoft SQL / MS SQL Server
    Replies: 2
    Last Post: August 5th, 03:42 PM
  4. format file and bcp/bulk insert
    By Robert Taylor in forum Microsoft SQL / MS SQL Server
    Replies: 5
    Last Post: July 7th, 11:26 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