Admin at 22:28, 10 August 2018

2018-08-10T22:28:47Z

← Older revision		Revision as of 22:28, 10 August 2018
Line 39:		Line 39:
	6. Right click <code>Package.dtsx</code> on the right side under the '''Solution Explorer''' and click '''View Code'''.		6. Right click <code>Package.dtsx</code> on the right side under the '''Solution Explorer''' and click '''View Code'''.

	:[[File:~~SSIS_FAQ_PublicKey_07~~-ViewCode.png\|link=]]		:[[File:SSIS_FAQ_PublicKey_03-ViewCode.png\|link=]]


	7. Use '''Ctrl+F''' to search for <code>PublicKeyToken</code> in the project to be updated.		7. Use '''Ctrl+F''' to search for <code>PublicKeyToken</code> in the project to be updated.

	:[[File:~~SSIS_FAQ_PublicKey_08~~-FindandReplace.png\|link=]]		:[[File:SSIS_FAQ_PublicKey_05-FindandReplace.png\|link=]]

Admin: Created page with "← SSIS:Data Quality Components {{CustomTOC}} In order to update your existing projects to a newer version of SQL Server, you will need t..."

2018-08-10T22:22:03Z

Created page with "← SSIS:Data Quality Components {{CustomTOC}} In order to update your existing projects to a newer version of SQL Server, you will need t..."

New page

[[SSIS:Data Quality Components|← SSIS:Data Quality Components]]
{{CustomTOC}}

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==
<span style="color:red;">'''''Warning: Please back up the original project file before starting.'''''</span>

1. Locate the <code>Package.dtsx</code> by going to '''View > Solution Explorer'''.

:[[File:SSIS_FAQ_PublicKey_01-LocatePackage.png|link=]]

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

:[[File:SSIS_FAQ_PublicKey_02-NewComponent.png|link=]]

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

:[[File:SSIS_FAQ_PublicKey_03-ViewCode.png|link=]]

:[[File:SSIS_FAQ_PublicKey_04-ViewCode.png|link=]]

4. Press (CTRL+F) to open the '''Find and Replace''' window. Type <code>PublicKeyToken</code> 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)

:[[File:SSIS_FAQ_PublicKey_05-FindandReplace.png|link=]]

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

:[[File:SSIS_FAQ_PublicKey_06-OldProject.png|link=]]

6. Right click <code>Package.dtsx</code> on the right side under the '''Solution Explorer''' and click '''View Code'''.

:[[File:SSIS_FAQ_PublicKey_07-ViewCode.png|link=]]

7. Use '''Ctrl+F''' to search for <code>PublicKeyToken</code> in the project to be updated.

:[[File:SSIS_FAQ_PublicKey_08-FindandReplace.png|link=]]

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.)

[[Category:FAQ]]
[[Category:SSIS:Data Quality Components]]

FAQ:SSIS:Update Public Key Token - Revision history

Admin at 22:28, 10 August 2018

Admin: Created page with "← SSIS:Data Quality Components {{CustomTOC}} In order to update your existing projects to a newer version of SQL Server, you will need t..."