ODBC Driver - MS SQL 2014 Compatible

Hi

We need an ODBC driver that is compatible with our MS SQL data warehouse in order to import activity data from our Radiology system.

We have set up an SSIS package that runs fine in de-bug mode with the SQL server setting as MS SQL Server 2016 but when we change this or attempt to run it as a job it fails to bring in the full datasets with no error message.

I have tried to determine the version of the driver that installed on the server but cannot see a readme file or any about information in the ODBC manager.

Please can you recommend a version (and where we can download it) that we can use successfully with SSIS?

Our server is Windows Server 2008 R2 Enterprise on a 64 bit system.

We are using Visual Studio 2015 to build the SSIS packages.

Our MS SQL version is MS SQL Server 2014:

Microsoft SQL Server Management Studio 12.0.5000.0
Microsoft Analysis Services Client Tools 12.0.5000.0
Microsoft Data Access Components (MDAC) 6.1.7601.17514
Microsoft MSXML 3.0 6.0
Microsoft Internet Explorer 9.11.9600.18665
Microsoft .NET Framework 4.0.30319.42000
Operating System 6.1.7601

Cheers

Geoff Pitt | Systems Developer
Tel: 01438 286 831 | Ext: 6831, Lister
East and North Hertfordshire NHS Trust
IM&T - Systems Development | LC355 | Gravely Annex | Lister Hospital | Corey's Mill Lane | Stevenage |
Hertfordshire | SG1 4AB | www.enherts-tr.nhs.uk<http://www.enherts-tr.nhs.uk/>

********************************************************************************************************************

This message may contain confidential information. If you are not the intended recipient please inform the
sender that you have received the message in error before deleting it.
Please do not disclose, copy or distribute information in this e-mail or take any action in relation to its contents. To do so is strictly prohibited and may be unlawful. Thank you for your co-operation.

NHSmail is the secure email and directory service available for all NHS staff in England and Scotland. NHSmail is approved for exchanging patient data and other sensitive information with NHSmail and other accredited email services.

For more information and to find out how you can switch, https://portal.nhs.net/help/joiningnhsmail