FAQ:SSIS:Update Public Key Token

From Melissa Data Wiki
Jump to navigation Jump to search

← SSIS:Data Quality Components

In order to update your existing projects to a newer version of SQL Server, you will need to edit the PublicKeyToken in the code designer page.

Before starting this process we recommend obtaining a list of all the components that utilize PublicKeyToken in the OLD projects.

Updating the PublicKeyToken in Existing Projects

Warning: Please back up the original project file before starting.

1. Locate the Package.dtsx by going to View > Solution Explorer.

SSIS FAQ PublicKey 01-LocatePackage.png

2. Go to the Data Flow tab and drag a NEW component from the SSIS Toolbox in order to get the NEW PublicKeyToken.

SSIS FAQ PublicKey 02-NewComponent.png

3. Right click the Package.dtsx on the right side in the Solution Explorer and click View Code (or alternatively hit F7). The following window should come up:

SSIS FAQ PublicKey 03-ViewCode.png
SSIS FAQ PublicKey 04-ViewCode.png

4. Press (CTRL+F) to open the Find and Replace window. Type PublicKeyToken in the Find what: field and click Find Next to locate and copy the NEW token value to wordpad. Save this token, it will be used to update the older projects experiencing the issue. (Ex. PublicKeyToken=aa80e80ec340a80c)

SSIS FAQ PublicKey 05-FindandReplace.png

5. Open the old project to be updated in Visual Studio.

SSIS FAQ PublicKey 06-OldProject.png

6. Right click Package.dtsx on the right side under the Solution Explorer and click View Code.

SSIS FAQ PublicKey 03-ViewCode.png

7. Use Ctrl+F to search for PublicKeyToken in the project to be updated.

SSIS FAQ PublicKey 05-FindandReplace.png

8. Once it is found, paste the NEW PublicKeyToken that was collected in step 4, in place of the existing one. Save the project. Now the PublicKeyToken has been updated. (Save, close, and then reopen.)