Monday, February 27, 2017

Schedule task not able to see UNC Path

if you batch script or schedule task not able to see UNC path

Uncheck  Do not store password

Wednesday, February 22, 2017

Saturday, February 11, 2017

SSISDB: PlEASE Create master key in database




USE [SSISDB]
OPEN master Key decryption by password = 'A006S@s2$'
ALTER MASTER KEY ADD ENCRYPTION BY SERVICE MASTER KEY
ALTER MASTER KEY ADD ENCRYPTION BY SERVICE MASTER KEY

Thursday, February 9, 2017