how to upgrade to the oct-17-2011 release

Jan 10, 2012 at 5:01 PM

The installer wants me to uninstall the older version, however, its not listed in my 'add/remove programs' -- I appear to be stuck... thanks...

Jan 24, 2012 at 1:52 PM

Does anyone know if there are guidelines for upgrading to the oct 17, 2011 release?  I uninstalled the previous version and installed the latest version however my job then fails with the below error.  The original SSIS pkg was created via BIDS on a dev server running SQL 2008 (10.0.4000) and it runs on a production server running SQL 2008 (10.50.2500).  Is there anyway to upgrade to the new oct-17-2011 release without bringing the dev server up to the same level as prod? 

 

Message

Executed as user: SYSAMA01\execsql. ...ta (PFC List) Write Data (PFC List) (SSIS.Pipeline)     Description: The "component "SharePoint List Source 1" (5996)" failed to cache the component metadata object and returned error code 0x80131600. End Error Error: 2012-01-24 07:05:44.95     Code: 0xC004706C     Source: Write Data (PFC List) Write Data (PFC List) (SSIS.Pipeline)     Description: Component "component "SharePoint List Source 1" (5996)" could not be created and returned error code 0xC0047067. Make sure that the component is registered correctly. End Error Error: 2012-01-24 07:05:44.95     Code: 0xC0048021     Source: Write Data (PFC List) Write Data (PFC List) (SharePoint List Source 1 [5996])     Description: The component is missing, not registered, not upgradeable, or missing required interfaces. The contact information for this component is "". End Error Error: 2012-01-24 07:05:44.95     Code: 0xC004801F     Source: Write Data (PFC List) Write Data (PFC List) (SSIS.Pipeline)     Description: The component metadata for "component "SharePoint List Source 1" (5996)" could not be upgraded to the newer version of the component. The PerformUpgrade method failed. End Error Error: 2012-01-24 07:05:44.98     Code: 0xC00490F7     Source: Delete All Records (Systems PFC Rollup) Delete All Records (Systems PFC Rollup) (SharePoint List Source [1])     Description: The managed pipeline component "Microsoft.Samples.SqlServer.SSIS.SharePointListAdapters.SharePointListSource, SharePointListAdapters, Version=1.0.0.0, Culture=neutral, PublicKeyToken=933a2c7edf82ac1f" could not be loaded. The exception was: Could not load file or assembly 'SharePointListAdapters, Version=1.0.0.0, Culture=neutral, PublicKeyToken=933a2c7edf82ac1f' or one of its dependencies. The system cannot find the file specified.. End Error Error: 2012-01-24 07:05:44.98     Code: 0xC0047067     Source: Delete All Records (Systems PFC Rollup) Delete All Records (Systems PFC Rollup) (SSIS.Pipeline)     Description: The "component "SharePoint List Source" (1)" failed to cache the component metadata object and returned error code 0x80131600. End Error Error: 2012-01-24 07:05:44.98     Code: 0xC004706C     Source: Delete All Records (Systems PFC Rollup) Delete All Records (Systems PFC Rollup) (SSIS.Pipeline)     Description: Component "component "SharePoint List Source" (1)" could not be created and returned error code 0xC0047067. Make sure that the component is registered correctly. End Error Error: 2012-01-24 07:05:44.98     Code: 0xC0048021   Source: Delete All Records (Systems PFC Rollup) Delete All Records (Systems PFC Rollup) (SharePoint List Source [1])     Description: The component is missing, not registered, not upgradeable, or missing required interfaces. The contact information for this component is "". End Error Error: 2012-01-24 07:05:44.98     Code: 0xC004801F     Source: Delete All Records (Systems PFC Rollup) Delete All Records (Systems PFC Rollup) (SSIS.Pipeline)     Description: The component metadata for "component "SharePoint List Source" (1)" could not be upgraded to the newer version of the component. The PerformUpgrade method failed. End Error Error: 2012-01-24 07:05:44.99     Code: 0xC00490F7     Source: Delete All Records (Systems PFC Rollup) Delete All Records (Systems PFC Rollup) (SharePoint List Destination [88])     Description: The managed pipeline component "Microsoft.Samples.SqlServer.SSIS.SharePointListAdapters.SharePointListDestination, SharePointListAdapters, Version=1.0.0.0, Culture=neutral, PublicKeyToken=933a2c7edf82ac1f" could not be loaded. The exception was: Could not load file or assembly 'SharePointListAdapters, Version=1.0.0.0, Culture=neutral, PublicKeyToken=933a2c7edf82ac1f' or one of its dependencies. The system cannot find the file specified.. End Error Error: 2012-01-24 07:05:44.99     Code: 0xC0047067     Source: Delete All Records (Systems PFC Roll... The package execution fa... The step failed.

Jan 31, 2012 at 3:43 PM

gkoonce, how did you upgrade?  I cannot see an 'uninstall' in the control panel and running the new version installer fails since I have the old version -- if I can get the old version uninstalled I can test and report to you anything I find during my upgrade....  thanks

Jan 31, 2012 at 4:07 PM

pkmccarthy, when I log into our database server, and select "control panel", then "programs and features", i can scroll down and find "SSIS SharePoint List Adaptors";  i click the "uninstall" button. 

Jan 31, 2012 at 4:07 PM

sorry, hit submit too soon - i then install the oct 17, 2011 version...

Apr 18, 2012 at 3:38 AM

I assume this is resolved now?

Apr 18, 2012 at 10:39 AM

Yes.  Of course I can't find the solution this morning but I will keep looking and post and update when it has been found.