Show SSIS project parameters in Visual Studio 2012

0 Comments

In SSIS 2012 there are two scopes on which parameters can be defined: – project – package   Projects parameters If you want to show / edit SSIS project parameters in Visual Studio 2012: Open

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

0 Comments

  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>  

Installing SSIS support in Microsoft Visual Studio 2012

0 Comments

As of 5-mrt-2013, Microsoft Visual Studio 2012 supports SSIS projects by installing Microsoft SQL Server Data Tools – Business Intelligence for Visual Studio 2012   You can download Microsoft SQL Server Data Tools – Business