I need to modify the existing SSIS package.
So I created a new project in BI Development Studio
and copied DTSX file that I need to modify to it.
I made a few changes, clicked "Save All", closed BID Studio.
When I opened this project again I realized that my changes were not saved. Is there something in the way the package was designed,
something in Package Properties maybe that prevents me from saving it?
When I loaded the existing file for the first time I had this error message:
Error 1 Error loading Niad_Export_To_File_NEW.dtsx: Failed to decrypt protected XML node "DTS:Password" 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. C:\SSIS\Niad_Export_To_File\Niad_Export_To_File\Niad_Export_To_File_NEW.dtsx 1 1