Questions tagged [ssis-2016]
SSIS 2016 is Microsoft SQL Server Integration Services 2016, and is part of SQL Server 2016. SSIS allows SQL Server to interact with other technologies, including import and export of data to and from other formats, or ETL, and data warehousing.
2 questions
1
vote
1
answer
734
views
SSIS Installation on Dedicated Server
We are planning on installing SSIS 2016 on a new dedicated ETL server.
The packages will be called from SQL Server Agent (on a separate server), or from an application (again on a separate server).
...
0
votes
1
answer
2k
views
Source - ODBC is not compatible with this version of the DataFlow
After deploying an SSIS package from a development server to another environment, execution and validation of the package fail with the following error:
Error: The version of #5) Source - ODBC - ...