The version of ODBC source is not compatible with

问题:

I have an SSIS package which I am running via DTEXec using a batch file, it looks like this:

cd C:\Program Files (x86)\SonicWALL\SSL-VPN\NetExtender
NECLI connect -s test.co.uk:4433 -d LocalDomain -u Development -p password

cd C:\Program Files\Microsoft SQL Server\120\DTS\Binn

dtexec.exe /f "\\local\it$\Application Development\.NET Projects\ReportingTool\Integration Services Project1\Integration Services Project1\Package.dtsx"

cd C:\Program Files (x86)\SonicWALL\SSL-VPN\NetExtender
NECLI disconnect

PAUSE
REM IF ERRORLEVEL 1 powershell -file C:\Users\admin\Documents\SendEmailScript_LIVE.ps1 -clientid 2

I use NetExtender to connect to our live server, this is so I can push data from our internal server to the live server. If I run the SSIS package in Visual Studio, it works fine. But when I try to run it via Exec, it fails. With this error: The version of ODBC source is not compatible with this version of the dataflow

Can anyone help?

回答1:

I have 2014 SQL Server installed on my machine. My SSIS package was referencing 2016 SQL Server. I'm not sure why this gave the error message listed in the title but hey ho. That's just how SSIS roles isn't it?

Previously the package was built in VS2013 which referenced 2014 SQL Server, so I swapped this around in the project properties and it worked.

Now time for the other errors which I am getting

回答2:

I had a very similar error message and updated SQL 2014 to SP2. This resolved the issue for me. Hopefully this will help someone else.