Thanks Frederico.

thank you

thank you

SQL service is running under Local System Account.

Is there any advantages of CT over CDC in this scenario for incremental data load to warehouse.

Can the incremental load using SSIS be run if the db is restored on...

Thanks Lowell.

Thanks Jeff.

Thanks Phil.

Thanks

Thanks Lowell. Can you please provide the code for 'CLR_ExportQueryToCSV'.

Solution:

ALTER the following views in SSIS catalog.

Catalog.event_messages

Catalog.executions

Catalog.validations

--Comment it to give access to reports

--WHERE opmsg.[operation_id] in (SELECT [id] FROM [internal].[current_user_readable_operations])

-- OR (IS_MEMBER('ssis_admin') = 1)

-- OR (IS_SRVROLEMEMBER('sysadmin') = 1)

After updating views,...

Thanks Grant. Do you have a documentation to accomplish this with out ssis.

Was trying to avoid linked servers(sql) and extra server level permissions(Windows).

Basically running an SSIS package from an instance will need to have access on sql server instance level, not...

Please help me to fix this procedure. This gives me error

Msg 229, Level 14, State 5, Procedure sp_StartAgentJobAndWait, Line 5

The EXECUTE permission was denied on the object 'sp_StartAgentJobAndWait', database...

Hi Phil, Do you have a script for this?