Cannot save changes in SSIS package

• JMI

  SSChampion

  Points: 11831

  More actions

  June 19, 2008 at 11:16 am

  #122101

  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:

  Error1Error 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.dtsx11

• ayerram 5353

  SSC Journeyman

  Points: 94

  More actions

  July 25, 2012 at 8:23 am

  #1517387

  How did you resolve your problem?I have same issue...