How do you store SQL passwords? Does the SSIS connection manager of the package store SQL password?

How do you store SQL passwords? Does the SSIS connection manager of the package store SQL password?

题目类型: 技术面试题

这是一道技术面试题，常见于澳洲IT公司面试中。

难度: hard

标签: interviewbit, ssis, topic-specific, etl, microsoft

参考答案摘要

The SSIS connection manager has issues in storing the password. Hence we can follow the below-proposed solutions: Method 1: Create and use SQL Server Agent Proxy account which uses credential that mak...

本题提供 STAR 原则详细解答和技术解析，登录匠人学院学习中心即可查看完整答案。