Hi
i have solved with next step:
- install Microsoft SQL Server 2016 Integration Services on BT machine
- create the SSISDB catalog on SQL Server machine
- in BizTalk 2020 configuration point to SQL Server 2017 Machine
Now working.
Beste regards
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi during the configuration's BizTalk 2020 appeare next error message: Microsoft SQL Server Integration Services (SSIS) is not installed on the local machine. The version of SSIS must be the equivalent version as on the SQL server of the BAM Archive Database. (14) Microsoft.SqlServer.ManagedDTS, version= 13.0.0.0 How can I solve it? Thanks in advance
Hi
i have solved with next step:
Now working.
Beste regards
Dear member,
Thank you for posting your question on the Microsoft Q&A platform.
This error is coming because you don't have SSIS not installed and you need to install Microsoft SQL Server 2016 Integration Services. This is bundled with SQL Server, but needs to be installed. SSIS is a useful integration tool that allows you to perform ETL tasks.
Kindly refer below MS doc link and screen-shot.
https://learn.microsoft.com/en-us/biztalk/install-and-config-guides/configure-biztalk-server#custom-configuration
Regards,
Kamlesh Kumar
Hi KamleshKumar
thank you for your answer. Where is necessary to install? I want BT and SQL in a separate machine then it is necessary to install on SQL Server machine?
Thanks in advance for your help
best regards
Hi
i have installed Microsoft SQL Server 2016 Integration Services on SQL Machine but the error persist. In SQL machine was installed the version Microsoft SQL Server 2017 (Database engine and integration Services). I must unistall all Microsoft SQL Server 2017? Both database engine and integration services?
Let me know
Thanks in advance