SSIS 2012 not showing correct Available External Columns in Xml Source Task.

  The “ORDER” type in the following XML document will not be shown in the available external columns dialog in SSIS 2012. <?xml version=”1.0″ encoding=”utf-8″?><ORDER>  <ID>1</ID>  <ORDERLINE>    <ID>1</ID>      <PRODUCTNAME>Test1</PRODUCTNAME>  </ORDERLINE>  <ORDERLINE>    <ID>2</ID>      <PRODUCTNAME>Test2</PRODUCTNAME>  </ORDERLINE></ORDER>   Result   If you want the ORDER type to show up, add a root element …

How to use a password field in a Kendo grid

The demo at http://demos.kendoui.com/web/grid/editing-custom.html shows how to create a custom editor function. We can use this function to show a password field as editor in a Kendo grid. function passwordEditor(container, options) { $(‘<input type="password" required data-bind="value:’ + options.field + ‘"/>’).appendTo(container); }; In the column that should be used as password, …

How to solve: Unable to open Transact-SQL file in custom editor in Microsoft Visual Studio 2012

In my case the error "Unable to open Transact-SQL file in custom editor", was caused by the fact, that I installed BIDS voor Microsoft Visual Studio 2012, but not the SSDT tools. After installing the SSDT tools, the error was resolved: http://msdn.microsoft.com/en-us/data/hh297027. This Microsoft download sites, works best on Internet …