It clearly states that you do NOT need to grant sys_admin privs...

source connection must have the sysadmin role, OR have the db_owner role and the SELECT permission...

and what part of "schema.objectname" don't you understand for you to have omitted one of the parts?

start with the lowest permission they mention - and then give it a try, with a trace in place to see which commands it is trying to execute.

then grant permissions...

post both the table definition AND the FULL SQL you are executing.

if you are querying views put the table definition of all involved tables within those views (and subviews if...

you need "view definition"

if you have CiberArk then you don't create a new password - just get a block of users added to a group A, add these to a Safe in CyberArk...

by the looks of it WED is a float - bad bad choice for almost anything and definitely very bad for a date.

-- as the column you...

have a look at this link https://techcommunity.microsoft.com/t5/sql-server-support-blog/ssis-package-fails-with-error-the-step-did-not-generate-any/ba-p/318301

and check windows event log.

can you post the exact command line you are using to execute the package - as well as the job step definition.

depending on how its being executed you may be...

what you need is to convert your script to something more clear and easier to maintain - and more robust as well.

from what I can see your intention is to...

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

if you are using SQL Azure or a contained database then you can't reference other db's - you need to know what you can and can't do with your particular...

'EXEC [' + @EnrichedViewDatabase + '].dbo.sp_executesql @'

it should be sys, not dbo

'EXEC [' + @EnrichedViewDatabase + '].dbo.sp_executesql @'

it should be sys, not dbo

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

you are not seeing what you wish because of how the row_number works (did you go and read the manual I gave?) - and as you didn't look at the...

Hi Frederico,

I really appreciate what you're doing for me, and may be its because I'm under pressure that I'm not fully understanding what you're driving at. However, I am...