SQL Server DBA Tutorial 130-How to Create SSIS Package Execution Proxy in SQL Server

preview_player
Показать описание
In this video you will learn how to create SSIS Package Execution Proxy in SQL Server. It shows step by step process of going through what exactly is SSIS Package Execution Proxy, how to create SSIS Package Execution credentials and how to create proxy using SSIS Package Execution credentials. It shows a scenario when it is good practice to use SSIS Package Execution proxy. It takes through best practices of creating Proxy in SQL Server.

Blog post link for Create SSIS Package Execution Proxy in SQL Server

Visit our website to check out SQL Server DBA Tutorial Step by Step
Рекомендации по теме
Комментарии
Автор

I hearty thank you Tech Brothers for making this tutorials for us. thanks a lot again...

akashparmar
Автор

I'm assuming you have some kind of Domain Trust between the two locations. Because there is no way to find an account from another domain using Entire Directory.

BoYcLuE
Автор

Thanks a lot sir, I have some strange issues, ssis job fails if I logged off from server, if I have active session on ETL server, than only job execute successfully.i m using proxy account, and account require rdp in order to have ssis successfull execution

a.useronly
Автор

One quick query, the account that you have used while setting the credential what is the password used. Any password will work or the password with which the account initially created have to use that.

sarthaks