{"action":"created","issue":{"url":"https://api.github.com/repos/serilog/serilog-sinks-mssqlserver/issues/10","labels_url":"https://api.github.com/repos/serilog/serilog-sinks-mssqlserver/issues/10/labels{/name}","comments_url":"https://api.github.com/repos/serilog/serilog-sinks-mssqlserver/issues/10/comments","events_url":"https://api.github.com/repos/serilog/serilog-sinks-mssqlserver/issues/10/events","html_url":"https://github.com/serilog/serilog-sinks-mssqlserver/pull/10","id":121715357,"number":10,"title":"Added column mappings for sql bulk copy","user":{"login":"enginkirmaci","id":253432,"avatar_url":"https://avatars.githubusercontent.com/u/253432?v=3","gravatar_id":"","url":"https://api.github.com/users/enginkirmaci","html_url":"https://github.com/enginkirmaci","followers_url":"https://api.github.com/users/enginkirmaci/followers","following_url":"https://api.github.com/users/enginkirmaci/following{/other_user}","gists_url":"https://api.github.com/users/enginkirmaci/gists{/gist_id}","starred_url":"https://api.github.com/users/enginkirmaci/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/enginkirmaci/subscriptions","organizations_url":"https://api.github.com/users/enginkirmaci/orgs","repos_url":"https://api.github.com/users/enginkirmaci/repos","events_url":"https://api.github.com/users/enginkirmaci/events{/privacy}","received_events_url":"https://api.github.com/users/enginkirmaci/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-12-11T14:15:38Z","updated_at":"2015-12-14T06:41:57Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/serilog/serilog-sinks-mssqlserver/pulls/10","html_url":"https://github.com/serilog/serilog-sinks-mssqlserver/pull/10","diff_url":"https://github.com/serilog/serilog-sinks-mssqlserver/pull/10.diff","patch_url":"https://github.com/serilog/serilog-sinks-mssqlserver/pull/10.patch"},"body":"- added column mappings for sql bulk copy which maps also additional columuns."},"comment":{"url":"https://api.github.com/repos/serilog/serilog-sinks-mssqlserver/issues/comments/164358722","html_url":"https://github.com/serilog/serilog-sinks-mssqlserver/pull/10#issuecomment-164358722","issue_url":"https://api.github.com/repos/serilog/serilog-sinks-mssqlserver/issues/10","id":164358722,"user":{"login":"enginkirmaci","id":253432,"avatar_url":"https://avatars.githubusercontent.com/u/253432?v=3","gravatar_id":"","url":"https://api.github.com/users/enginkirmaci","html_url":"https://github.com/enginkirmaci","followers_url":"https://api.github.com/users/enginkirmaci/followers","following_url":"https://api.github.com/users/enginkirmaci/following{/other_user}","gists_url":"https://api.github.com/users/enginkirmaci/gists{/gist_id}","starred_url":"https://api.github.com/users/enginkirmaci/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/enginkirmaci/subscriptions","organizations_url":"https://api.github.com/users/enginkirmaci/orgs","repos_url":"https://api.github.com/users/enginkirmaci/repos","events_url":"https://api.github.com/users/enginkirmaci/events{/privacy}","received_events_url":"https://api.github.com/users/enginkirmaci/received_events","type":"User","site_admin":false},"created_at":"2015-12-14T06:41:57Z","updated_at":"2015-12-14T06:41:57Z","body":"Hi @nblumhardt,\r\nI made this change because of it gives me a string to Datetime parse error, while sql bulk copy. After a bit search, sql bulk copy didn't match columns automatically. if we don't provide mapping, it looks to same column order for table we created and db has. With this change we don't need the same order. So that, additional columns works.\r\n"}}