none
Strange package run error SQL Server 2008

    Question

  • Hi All,

    I have managed to fix my SSIS XML connection config issue and run successfully the package by itself / reployed.
    Now when I run my schedule I am getting the following error, whereas before i didnt.

    I have done some searching and checked the versions between my client computer and the server they are the same..

    Date        14/01/2013 3:24:35 PM
    Log        Job History (MI Refresh - Initial Load)

    Step ID        3
    Server        WNAB612287\AWD_DATAMART
    Job Name        MI Refresh - Initial Load
    Step Name        SharePointToDatamartUpdates
    Duration        00:00:01
    Sql Severity        0
    Sql Message ID        0
    Operator Emailed        
    Operator Net sent        
    Operator Paged        
    Retries Attempted        0

    Message
    Executed as user: WNAB612287\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 10.0.2531.0 for 32-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  3:24:35 PM  Error: 2013-01-14 15:24:36.17     Code: 0xC0047062     Source: SP to Temp SharePoint List Source 1 [108]     Description: System.IO.FileNotFoundException: Could not load file or assembly 'System.Xml.Linq, Version=3.5.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. The system cannot find the file specified.  File name: 'System.Xml.Linq, Version=3.5.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'     at Microsoft.Samples.SqlServer.SSIS.SharePointListAdapters.SharePointListSource.Validate()     at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostValidate(IDTSManagedComponentWrapper100 wrapper)    WRN: Assembly binding logging is turned OFF.  To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.  Note: There is some performance penalty associated with assembly bind failure logging.  To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].  End Error  Error: 2013-01-14 15:24:36.17     Code: 0xC0047017     Source: SP to Temp SSIS.Pipeline     Description: component "SharePoint List Source 1" (108) failed validation and returned error code 0x80070002.  End Error  Error: 2013-01-14 15:24:36.17     Code: 0xC004700C     Source: SP to Temp SSIS.Pipeline     Description: One or more component failed validation.  End Error  Error: 2013-01-14 15:24:36.17     Code: 0xC0024107     Source: SP to Temp      Description: There were errors during task validation.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  3:24:35 PM  Finished: 3:24:36 PM  Elapsed:  0.983 seconds.  The package execution failed.  The step failed.

    Monday, January 14, 2013 4:37 AM

Answers

All replies

  • Taking a guess that its because my Server doesnt have .NET 3.5 on it?
    Monday, January 14, 2013 5:21 AM
  • hi bradley

    this is the error

    'System.Xml.Linq, Version=3.5.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. The system cannot find the file specified.  File name: 'System.Xml.Linq, Version=3.5.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'     at Microsoft.Samples.SqlServer.SSIS.SharePointListAdapters.SharePointListSource.Validate()     at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostValidate(IDTSManagedComponentWrapper100 wrapper)    WRN: Assembly binding logging is turned OFF. 

    pls check whether ur referring to linq namespace or .net framework contains linq namespace, if not pls install.

    regards

    Naveen

    Tuesday, January 15, 2013 10:44 AM
  • Taking a guess that its because my Server doesnt have .NET 3.5 on it?
    That's seems very likely.

    MCSA SQL Server 2012 - Please mark posts as answered where appropriate.

    Tuesday, January 15, 2013 10:55 AM
  • The lowest version of .Net that supports linq is 3.5: http://msdn.microsoft.com/nl-nl/library/system.xml.linq(v=vs.90).aspx

    Check Control panel > Software for this version or check  the folder C:\Windows\Microsoft.NET\Framework


    Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

    • Marked as answer by Eileen Zhao Thursday, January 24, 2013 3:20 AM
    Tuesday, January 15, 2013 11:06 AM