We have a SSIS package developed by a 3rd-party. When I access the package in Visual Studio using the password of the 3rd -party, everything looks normal.
However, when I log into the Visual Studio using my own user name and password, I can see the package, but data can't be loaded. Below is the error message. Our IT told me that they have given me access to the database, why I'm still having permission issue?
|Error||Error loading SAP By Design Read Facts.dtsx: Failed to decrypt protected XML node Property with error 0x8009000B Key not valid for use in specified state.. You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available.|
|Error||Validation error. Fact_Baseline Days CData SAPByDesign Source: Unable to get the schema of the data source.||SAP By Design Read Facts.dtsx||0|