Skip to main content
Dynamics 365 general forum
Unanswered

SSIS Job executes only with SQL Admin rolled account when 2 DBs are in Linked DBs

editSubscribe (0) ShareShare
ReportReport
Posted on by
Hi Experts,
I have developed SSIS package to do ETL the data from external system to D365 intranet on-prem system.
Raw Data is received by custom Database (StagingDB). Upon transforming the staging data, it will be processed to CRM DB.
Both the StagingDB & CRM DB has joint by LinkedDB. The SSIS package had configured as SSIS Job and scheduled. 
 
Issue: The SSIS scheduled job is running when the execution account has DB admin privilege. Otherwise the SSIS job is not executing properly and prompt the privilege issue. 
Query: Do we need to have the SQL DB Admin privilege for the SSIS job execution account when 2 different linkedDB invole? Or any alternate step to overcome this issue? Please share your thoughts.
 
 
Thanks,
Muthukumar Murugan
pearlcrmsg@gmail.com
Categories:

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,066 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,585 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans