Software Requirements

Parent Previous Next


Software Requirements


  SQL Server Integration Services 2005, 2008, 2012, 2014, 2016, or 2017

  BIDS 2005 or 2008 (Business Intelligence Development Studio) or SQL Server Data Tools 2012, 2014, 2016 (for Visual Studio 2015), or 2017 (for Visual Studio 2015 or 2017)


Important Notes

SSDT is a development environment requirement, however, it is not required on a server installation.


The following operating systems are supported by Workbench:

  64-bit (x64) Operating Systems:

o   Windows Server 2003 (at least Service Pack 2) *

o   Windows Vista (at least Service Pack 2)

o   Windows Server 2008 R2

o   Windows Server 2012

o   Windows Server 2016

o   Windows 7

o   Windows 8

o   Windows 10

  32-bit (x86) Operating Systems:

o   Windows XP (at least Service Pack 3) *

o   Windows Server 2003 (at least Service Pack 3) *

o   Windows Vista (at least Service Pack 2)

o   Windows Server 2008 R2

o   Windows Server 2012

o   Windows 7

o   Windows 8

o   Windows 10


Important Notes

Windows XP and Server 2003 have been deprecated from full support. Any issues encountered on either Windows XP or Server 2003 must be reproducible on newer versions of Windows to be eligible for support.


A few of our customers have encountered issues with Windows Server 2003 installations of Task Factory. Packages with Task Factory may not run until the Windows 2003 server is restarted. If you are planning on installing Task Factory on Windows 2003, please wait until you can reboot the machine or restart the SSIS Service after installation.


Additional Requirements


   Oracle Upsert Destination Requirements

o   For 64-bit Task Factory:

  64-bit Oracle Data Access Components (ODAC) 11g with Oracle Developer Tools for Visual Studio

  64-bit Oracle 12c Managed Data Access Client

o   For 32-bit Task Factory:

  32-bit Oracle Data Access Components (ODAC) 11g with Oracle Developer Tools for Visual Studio

  32-bit Oracle 12c Managed Data Access Client


Check if BIDS or SQL Server Data Tools is Installed


To check if BIDS is installed open Start  > All Programs > Microsoft SQL Server 2005, 2008, 2012, or 2014. You should be able to see Business Intelligence Development Studio or SQL Server Data Tools if it is installed.


 


Check if SSIS Components are Installed


1.   Open BIDS or SQL Server Data Tools.


2.   Once open, click File > New > Project.



3.   In the "New Project" dialog box, select "Business Intelligence Projects" on the left hand side. If you see "Integration Services Project" on the right hand side, then the SSIS components are installed.