its a matter of choice - but I personally do not use project connections, only project parameters.

Connections are all defined within each package that needs them - and the connection...

as Phil said - don't save sensitive parameters. e.g. set packages to "DontSaveSensitive"

while this has a downside in that sensitive parameters are not saved, there are ways around it so...

why don't you try it on dev, on a copy of the table with all required indexes? asking us here for something you can try yourself is a waste of...

• This reply was modified 2 years, 3 months ago by frederico_fonseca.

as ratbak said you will need to change the clustered index to have the partitioned column as its first (not sure if unique) column.

and in order to allow for the...

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, 3 months 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 -...