My current solution is to switch the Linked Server to ODBC instead of OLEDB

EXEC master.dbo.sp_addlinkedserver @server = N'<linked_server_name', @srvproduct=N'', @provider=N'MSDASQL', @provstr=N'Driver={ODBC Driver 18 for SQL Server};Server=<server_name>;Trusted_Connection=yes;TrustServerCertificate=yes;Encrypt=yes;'

However a...

• This reply was modified 1 year ago by  christian_t.

Thank you Ken, this would be a mitigation of the problem.

As it is currently only used in stored procedure, is there a hint (SET something), so that I do not...

Hi,

I tried this option but it does not change the behaviour. I tried also the option from the driver settings, however I am just doing a SELECT in the procedure...

Hi DinoRS,

thx. It seems to be a solution, after browsing the information and the documentation of JDBC-drivers at MS.

However I did not see any reference to SSIS. Is it possible...

actually no,

if you run it like this
DECLARE @value varbinary(8000/max) = 0x123456789
SELECT *
FROM table
WHERE encrypted_column = @value

currently this encrypted deterministic, so same value = same varbinary.
If it is possible, what would be the syntax for that?

Hi Lowel,

thanks for your reply. I am actually not using SSMS. This is a task in an ETL (dtsx-Package).
I am using OLEDB-Source for that specify task....

Hi Vinoth,

what I did is, to create a dedicated schedule that ended in the past e.g. 01.01.2017. For every subscription that I wanted to trigger when the data...

Additionally if you do not have no SA you always have to licence the newest version

In your example SQL 2012 + 2014 you need a Licence SQL 2014 or...

This is how you can fix it, before MS delivers the right solution:

After the package is migrated you find in the XML-Code following part

<DTS:DesignTimeProperties><![CDATA[<?xml version="1.0"?>

<!--This CDATA section contains the layout...

It would work, when the sql writes the result in a table instead of using it in a dataflow.

Properly it would get quite confusing, when you have 20-30 page size...

I opened an SQL Connect Bug

https://connect.microsoft.com/SQLServer/feedback/details/1438953

the devil is in the details...

Thx for clarifying this

Christian

Hi Gila,

do you have any M$ documentation for that?

I did not find anything in the description of the SQL Server 2014 descriptions and Upgrade Advisors.

🙁

Christian

I used the code from the site mentioned above and modified it a little bit.

I wanted to go through all our dtsx-Packages and at the Variable if it did NOT...