Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 9EE82200B59 for ; Mon, 8 Aug 2016 15:27:40 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 9D74F160A91; Mon, 8 Aug 2016 13:27:40 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id BB6E5160A77 for ; Mon, 8 Aug 2016 15:27:39 +0200 (CEST) Received: (qmail 64184 invoked by uid 500); 8 Aug 2016 13:27:38 -0000 Mailing-List: contact users-help@nifi.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@nifi.apache.org Delivered-To: mailing list users@nifi.apache.org Received: (qmail 64174 invoked by uid 99); 8 Aug 2016 13:27:38 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 08 Aug 2016 13:27:38 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 51BB5180B10 for ; Mon, 8 Aug 2016 13:27:38 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.979 X-Spam-Level: * X-Spam-Status: No, score=1.979 tagged_above=-999 required=6.31 tests=[HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001] autolearn=disabled Received: from mx2-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id C3XJVox-jRKa for ; Mon, 8 Aug 2016 13:27:36 +0000 (UTC) Received: from SNT004-OMC2S51.hotmail.com (snt004-omc2s51.hotmail.com [65.54.61.102]) by mx2-lw-eu.apache.org (ASF Mail Server at mx2-lw-eu.apache.org) with ESMTPS id CF1465F476 for ; Mon, 8 Aug 2016 13:27:35 +0000 (UTC) Received: from EUR01-VE1-obe.outbound.protection.outlook.com ([65.55.90.72]) by SNT004-OMC2S51.hotmail.com over TLS secured channel with Microsoft SMTPSVC(7.5.7601.23008); Mon, 8 Aug 2016 06:27:28 -0700 Received: from DB5EUR01FT005.eop-EUR01.prod.protection.outlook.com (10.152.4.54) by DB5EUR01HT066.eop-EUR01.prod.protection.outlook.com (10.152.5.236) with Microsoft SMTP Server (version=TLS1_0, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA_P384) id 15.1.567.7; Mon, 8 Aug 2016 13:27:27 +0000 Received: from VI1PR01MB1101.eurprd01.prod.exchangelabs.com (10.152.4.56) by DB5EUR01FT005.mail.protection.outlook.com (10.152.4.131) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384_P384) id 15.1.567.7 via Frontend Transport; Mon, 8 Aug 2016 13:27:25 +0000 Received: from VI1PR01MB1101.eurprd01.prod.exchangelabs.com ([10.162.118.143]) by VI1PR01MB1101.eurprd01.prod.exchangelabs.com ([10.162.118.143]) with mapi id 15.01.0549.025; Mon, 8 Aug 2016 13:27:24 +0000 From: Guillaume Pool To: "users@nifi.apache.org " Subject: Insert null into SQLServer Table from JSONtoSQL processor Thread-Topic: Insert null into SQLServer Table from JSONtoSQL processor Thread-Index: AQHR8XiZPn6z4K12DU+bI9Q0yIlogw== Date: Mon, 8 Aug 2016 13:27:24 +0000 Message-ID: Accept-Language: en-ZA, en-US Content-Language: en-ZA X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: spf=softfail (sender IP is 10.152.4.56) smtp.mailfrom=live.co.za; nifi.apache.org; dkim=none (message not signed) header.d=none;nifi.apache.org; dmarc=none action=none header.from=live.co.za; received-spf: SoftFail (protection.outlook.com: domain of transitioning live.co.za discourages use of 10.152.4.56 as permitted sender) x-ms-exchange-messagesentrepresentingtype: 1 x-tmn: [+yVncL9Q+nUvlxfxQsj0761JeLpfNh4X] x-eopattributedmessage: 0 x-forefront-antispam-report: CIP:10.152.4.56;IPV:NLI;CTRY:;EFV:NLI;SFV:NSPM;SFS:(10019020)(98900003);DIR:OUT;SFP:1102;SCL:1;SRVR:DB5EUR01HT066;H:VI1PR01MB1101.eurprd01.prod.exchangelabs.com;FPR:;SPF:None;LANG:en; x-microsoft-exchange-diagnostics: 1;DB5EUR01HT066;6:vU4NNJfCuOedbA5P7Ah5lNmigkPnx5DltBvj+F30n2CEKrX/F9f/DEByE+FSdwn09hnSLCQC3RIizurnipAX5xmzP92CWS5rsfbvCNKR8LnA+9ksOnNlUpczbvPyfO1uNuI6u1wdI0SpH7A4NBe12wVJip0R3ORmiyoSPAB1+a5jh+YIbo9mFksd6wNId7avmYdW4FCqzlSGCN4kwiq0xKlGBfiYO9Bt0Ed4bejlAdzgW/r5gY82nbqauI+wP62R/m9jL8ixKvBmzpLAy/tIBua/DAlSUliOvHWlUttcJ0wexYWIJWRZg0Cc+4qBp8+v;5:BthnrNiyNW0oZwK5I7MzdzGqVEzlLnwmhh/4EfaGDMO7J60f44fOnoKIEg7hQ2ToiWydoELCwb23dZYCFIQRRTgoLCMuSv0ByBa2l6598z4py8SsDP2aUSlMvrw2y73iYanTXXCq9WhGas3GYLTHsg==;24:fhlG/MPXH089fitWsoIUivTmyinskix8MWJtKwP34Llbecuk/uBXWDRUDzkjX5x3VseAIT/eFBHvccLF2uO8IYK1qdbd5SU6eAj0IrPfDLg=;7:7ASIH9/7QRSQHWwboYoeLj8bZMb7T/MP5mInog/aSAeDhusWNTmbMvI7Hzfh2930TnkbZl4374b0L4zpRjuXe1aG0e58YaBy4NGLyL91u6hBezAmrdac8pZAY3xB08YCV1ePRAbU5XNfzjiYnVhoKsTeFYw7nDYEZkWKaSyaHqwImLdypb2aVx0YmPGnRT2xUNgmZlb39xOvtUa/hpdxfgJeqU4HJfjdVTYROzrczB/tIG5QuYR2aXXY6C+o5MUC x-ms-office365-filtering-correlation-id: d42e2967-e332-4be8-2c14-08d3bf8fbc26 x-microsoft-antispam: UriScan:;BCL:0;PCL:0;RULEID:(1601124038)(1601125047);SRVR:DB5EUR01HT066; x-exchange-antispam-report-cfa-test: BCL:0;PCL:0;RULEID:(432015012)(82015046);SRVR:DB5EUR01HT066;BCL:0;PCL:0;RULEID:;SRVR:DB5EUR01HT066; x-forefront-prvs: 00286C0CA6 spamdiagnosticoutput: 1:99 spamdiagnosticmetadata: NSPM Content-Type: multipart/alternative; boundary="_000_VI1PR01MB110192A891607C61306BC1A1801B0VI1PR01MB1101eurp_" MIME-Version: 1.0 X-OriginatorOrg: outlook.com X-MS-Exchange-CrossTenant-originalarrivaltime: 08 Aug 2016 13:27:24.6848 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Internet X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa X-MS-Exchange-Transport-CrossTenantHeadersStamped: DB5EUR01HT066 X-OriginalArrivalTime: 08 Aug 2016 13:27:28.0927 (UTC) FILETIME=[9C30D2F0:01D1F178] archived-at: Mon, 08 Aug 2016 13:27:40 -0000 --_000_VI1PR01MB110192A891607C61306BC1A1801B0VI1PR01MB1101eurp_ Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 SGksDQoNCklzIHRoZXJlIGFueSB3YXkgSSBjYW4gc3BlY2lmeSB0aGUgbnVsbCB2YWx1ZSBmb3Ig YSBmaWVsZCB0byBiZSB0aGUgZXF1aXZhbGVudCBvZiBTUUwgbnVsbCB2YWx1ZSBpbiBhbiB1cGRh dGUgYXR0cmlidXRlcyBzdGF0ZW1lbnQgdXNpbmcgZXhwcmVzc2lvbiBsYW5ndWFnZS4NCg0KVGhl IG91dHB1dCBpcyBlaXRoZXIgTlVMTCAoc2VlbXMgdG8gdHJ5IHRvIGxvYWQgdGhhdCBhcyBhIHN0 cmluZykgb3Ig4oCY4oCZLCBhbmQgSSBnZXQgYW4gZXJyb3IgdGhhdCBpdCBjYW5ub3QgY29udmVy dCB0aGF0IHN0cmluZyB2YWx1ZSBpbnRvIEdVSUQuDQoNClRoYW5rcw0KR3VpbGxhdW1lDQoNCg== --_000_VI1PR01MB110192A891607C61306BC1A1801B0VI1PR01MB1101eurp_ Content-Type: text/html; charset="utf-8" Content-ID: Content-Transfer-Encoding: base64 PGh0bWwgeG1sbnM6bz0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTpvZmZpY2U6b2ZmaWNlIiB4 bWxuczp3PSJ1cm46c2NoZW1hcy1taWNyb3NvZnQtY29tOm9mZmljZTp3b3JkIiB4bWxuczptPSJo dHRwOi8vc2NoZW1hcy5taWNyb3NvZnQuY29tL29mZmljZS8yMDA0LzEyL29tbWwiIHhtbG5zPSJo dHRwOi8vd3d3LnczLm9yZy9UUi9SRUMtaHRtbDQwIj4NCjxoZWFkPg0KPG1ldGEgaHR0cC1lcXVp dj0iQ29udGVudC1UeXBlIiBjb250ZW50PSJ0ZXh0L2h0bWw7IGNoYXJzZXQ9dXRmLTgiPg0KPG1l dGEgbmFtZT0iR2VuZXJhdG9yIiBjb250ZW50PSJNaWNyb3NvZnQgV29yZCAxNSAoZmlsdGVyZWQg bWVkaXVtKSI+DQo8c3R5bGU+PCEtLQ0KLyogRm9udCBEZWZpbml0aW9ucyAqLw0KQGZvbnQtZmFj ZQ0KCXtmb250LWZhbWlseToiQ2FtYnJpYSBNYXRoIjsNCglwYW5vc2UtMToyIDQgNSAzIDUgNCA2 IDMgMiA0O30NCkBmb250LWZhY2UNCgl7Zm9udC1mYW1pbHk6Q2FsaWJyaTsNCglwYW5vc2UtMToy IDE1IDUgMiAyIDIgNCAzIDIgNDt9DQovKiBTdHlsZSBEZWZpbml0aW9ucyAqLw0KcC5Nc29Ob3Jt YWwsIGxpLk1zb05vcm1hbCwgZGl2Lk1zb05vcm1hbA0KCXttYXJnaW46MGNtOw0KCW1hcmdpbi1i b3R0b206LjAwMDFwdDsNCglmb250LXNpemU6MTEuMHB0Ow0KCWZvbnQtZmFtaWx5OiJDYWxpYnJp IixzYW5zLXNlcmlmO30NCmE6bGluaywgc3Bhbi5Nc29IeXBlcmxpbmsNCgl7bXNvLXN0eWxlLXBy aW9yaXR5Ojk5Ow0KCWNvbG9yOmJsdWU7DQoJdGV4dC1kZWNvcmF0aW9uOnVuZGVybGluZTt9DQph OnZpc2l0ZWQsIHNwYW4uTXNvSHlwZXJsaW5rRm9sbG93ZWQNCgl7bXNvLXN0eWxlLXByaW9yaXR5 Ojk5Ow0KCWNvbG9yOiM5NTRGNzI7DQoJdGV4dC1kZWNvcmF0aW9uOnVuZGVybGluZTt9DQouTXNv Q2hwRGVmYXVsdA0KCXttc28tc3R5bGUtdHlwZTpleHBvcnQtb25seTt9DQpAcGFnZSBXb3JkU2Vj dGlvbjENCgl7c2l6ZTo2MTIuMHB0IDc5Mi4wcHQ7DQoJbWFyZ2luOjcyLjBwdCA3Mi4wcHQgNzIu MHB0IDcyLjBwdDt9DQpkaXYuV29yZFNlY3Rpb24xDQoJe3BhZ2U6V29yZFNlY3Rpb24xO30NCi0t Pjwvc3R5bGU+DQo8L2hlYWQ+DQo8Ym9keSBsYW5nPSJFTi1aQSIgbGluaz0iYmx1ZSIgdmxpbms9 IiM5NTRGNzIiPg0KPGRpdiBjbGFzcz0iV29yZFNlY3Rpb24xIj4NCjxwIGNsYXNzPSJNc29Ob3Jt YWwiPkhpLDwvcD4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxvOnA+Jm5ic3A7PC9vOnA+PC9wPg0K PHAgY2xhc3M9Ik1zb05vcm1hbCI+SXMgdGhlcmUgYW55IHdheSBJIGNhbiBzcGVjaWZ5IHRoZSBu dWxsIHZhbHVlIGZvciBhIGZpZWxkIHRvIGJlIHRoZSBlcXVpdmFsZW50IG9mIFNRTCBudWxsIHZh bHVlIGluIGFuIHVwZGF0ZSBhdHRyaWJ1dGVzIHN0YXRlbWVudCB1c2luZyBleHByZXNzaW9uIGxh bmd1YWdlLjwvcD4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxvOnA+Jm5ic3A7PC9vOnA+PC9wPg0K PHAgY2xhc3M9Ik1zb05vcm1hbCI+VGhlIG91dHB1dCBpcyBlaXRoZXIgTlVMTCAoc2VlbXMgdG8g dHJ5IHRvIGxvYWQgdGhhdCBhcyBhIHN0cmluZykgb3Ig4oCY4oCZLCBhbmQgSSBnZXQgYW4gZXJy b3IgdGhhdCBpdCBjYW5ub3QgY29udmVydCB0aGF0IHN0cmluZyB2YWx1ZSBpbnRvIEdVSUQuPG86 cD48L286cD48L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48bzpwPiZuYnNwOzwvbzpwPjwvcD4N CjxwIGNsYXNzPSJNc29Ob3JtYWwiPlRoYW5rczwvcD4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPkd1 aWxsYXVtZTwvcD4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxzcGFuIHN0eWxlPSJmb250LXNpemU6 MTIuMHB0O2ZvbnQtZmFtaWx5OiZxdW90O1RpbWVzIE5ldyBSb21hbiZxdW90OyxzZXJpZiI+PG86 cD4mbmJzcDs8L286cD48L3NwYW4+PC9wPg0KPC9kaXY+DQo8L2JvZHk+DQo8L2h0bWw+DQo= --_000_VI1PR01MB110192A891607C61306BC1A1801B0VI1PR01MB1101eurp_--