Trying to open some old SSIS projects to make changes but got error messages. The project has some SSIS packages with format .dtsx, there there are a couple of errors:
Error 4 Error loading Test.dtsx: Failed to decrypt protected XML node "DTS: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 5 Error loading Test.dtsx: The connection type "SFTPConnection" specified for connection manager "TF SFTP Connection Manager TEST" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name.
Error 6 Error loading Test.dtsx: Error loading value "
Error 7 Error loading 'Test.dtsx' : The package failed to load due to error 0xC0010014 "One or more error occurred. There should be more specific errors preceding this one that explains the details of the errors. This message is used as a return value from functions that encounter errors.". This occurs when CPackage::LoadFromXML fails.
I have installed Sql server data tools SSDT for 2010, 2012 and 2013, Visual studio 2010, 2012, 2013, Sql management studio 2012. Sorry if this doesn't make sense as I am new to SSIS and not sure what is going on.
Edit: Tried to set protection to DontSaveSensitive but still not working
User contributions licensed under CC BY-SA 3.0