Import Multiple CSV Files to SQL Server from a Folder -


i have folder called "dump." folder consists of variouos .csv files. folder location 'c:\dump'

i want import contents of these files sql server. want rough code along proper comments understand it.

i have tried few codes found on net. haven't quite worked out me strange reason.

the steps have are

step 1: copy file names in folder table

step 2: iterate through table , copy data files using bulk insert.

someone please me out on one. lot in advance :)

    --bulk insert multiple files folder       --a table loop thru filenames drop table allfilenames     create table allfilenames(whichpath varchar(255),whichfile varchar(255))      --some variables     declare @filename varchar(255),             @path     varchar(255),             @sql      varchar(8000),             @cmd      varchar(1000)       --get list of files process:     set @path = 'c:\dump\'     set @cmd = 'dir ' + @path + '*.csv /b'     insert  allfilenames(whichfile)     exec master..xp_cmdshell @cmd     update allfilenames set whichpath = @path whichpath null       --cursor loop     declare c1 cursor select whichpath,whichfile allfilenames whichfile '%.csv%'     open c1     fetch next c1 @path,@filename     while @@fetch_status <> -1       begin       --bulk insert won't take variable name, make sql , execute instead:        set @sql = 'bulk insert temp ''' + @path + @filename + ''' '            + '     (                     fieldterminator = '','',                     rowterminator = ''\n'',                     firstrow = 2                  ) '     print @sql     exec (@sql)        fetch next c1 @path,@filename       end     close c1     deallocate c1       --extras      --delete allfilenames whichfile null     --select * allfilenames     --drop table allfilenames

Comments

Post a Comment

Popular posts from this blog

Why does Ruby on Rails generate add a blank line to the end of a file? -

running rails generate controller foo home results in: class foocontroller < application controller def home end end (there's nothing on line in actual file, blank line) is there purpose blank line? it's common use newline indicate end of line, last line. many editors (like vi, use) add in newline silently. consensus text files (especially in unix world) should end in newline, , there have been problems historically if wasn't present. why should text files end newline? the tool used count lines in file "wc" counts newlines in file, without trailing newline show 3 instead of 4. it improves readability of templates used in generator. consider: https://github.com/rails/rails/blob/master/railties/lib/rails/generators/rails/controller/templates/controller.rb to remove trailing newline, template have last line of: end<% end -%> instead of: end <% end -%> that seems less readable me. the discussion below refers ...
Read more

keyboard - Smiles and long press feature in Android -

i've created android keyboard. how add features inserting smilies, , using long keypresses display symbols? to create long-press behavior allows select several options pop-up menu, follow guide (specifically pop-up menu section): http://developer.android.com/guide/topics/ui/menus.html smileys (also known emoticons) combination of keys, understood programs , parsed same way. have do, when clicks smiley face on keyboard, simulate pressing of key combination matching emoticon. example, when clicks smiley, should simulate key presses ':' , ')' :). here's list of emoticons: http://en.wikipedia.org/wiki/list_of_emoticons
Read more

node.js - Bad Request - node js ajax post -

i'm using express 3.0 , node v0.11.0. have button submits form , i'm using ajax post data json object node server. client code is: $('#contact').submit(function(e) { console.log('submit called'); var formdata = json.stringify($('form').serializeobject()); console.log(formdata); $.ajax({ url: "http://localhost:3000/savedata/", type: "post", datatype: 'json', data: {objectdata: formdata}, contenttype: "application/json", complete: function() { console.log('process complete'); }, success: function(data) { console.log('process sucess'); }, error: function() { console.log('process error'); }, }); return false; }); then on server: var express = require('express'); var app = express(); app.set('views', __dirname + '/views'); app.set('view engine', 'jade'); app.use(express.bodyparser());...
Read more