and did you bother googling for it or even asking the vendor? just searching for the error message gave me lots of hits including the solution.

SSIS catalog  DOES NOT allow for double hop - so if you execute on server A (through SSMS on your own PC) and the package needs to run as YOURSELF...

what I would suggest is adding a hashbytes (SHA-1) for the document name - and another for fullpath - and use those in both incoming and permanent tables to do...

that was a very important aspect to omit.

try this - without the current explain plan its impossible to know if it will help

WITH MaxD AS (select t1.*...

having explain plan would be the best thing for us to help - there are a few things on your query that don't look right.

-- original query...

issue is connectivity between your SQL server and your AD domain controllers , and potentially a few more network issues.

when using Windows Authentication the Server needs to validate with a...

a few other things will affect performance of delete.

does it have triggers

does it have links to other tables (and is cascade delete enabled) e.g. is part of a parent/child foreign...

19, 0 not enough as the data being truncated has at least 2 decimal places according to the error.

to the OP - if you don't know what the size should...

you can't - and a better option would likely be for  you to start using VS database projects and keep all your objects on it - easy to integrate with...

• This reply was modified 2 years ago by frederico_fonseca.

and what have you found in google? lots of hits including some in this site

its not the it corrupts - but if when running a package the user unsets a required parameter it may be defaulting to what is "hardcoded" on the package -...

have a look at attached spreadsheet - it is what I use to setup my servers.

on your case you will need to manually ensure that the SSAS memory does not...

• This reply was modified 2 years ago by frederico_fonseca.

lots of info on google - here is one https://www.progress.com/tutorials/odbc/connect-to-postgresql-database-from-sql-server-linked-server

you been advised to do process clear before process full - you still not doing it based on  your last script.

you rmemory (tabular) likely not set correctly either - as...

likely you need "set nocount on" at the top of your SP (it should be in ALL of them really)