the way it is done, on many companies, is to restore the DB on a PROD server (can be same server as the source if server has the required capacity)),...

let me put it in a different way.

do those packages access any server other than the one where SSIS package is installed and running, and is the connection to those...

that message is a typical windows authentication double hop issue (which SSIS Catalog does NOT support).

has NOTHING to do with permissions just to be clear.

so... when you execute the package...

this is why you should supply consumable data and desired output.

so on above example, how do we link between tbl1 and tbl2? this is assuming that there are more than...

error is very clear - your bulk insert is failing because of data conversion between input (your file) and the output (#TEMP_TABLE).

it has Nothing to do with that flag or...

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