none
Passing a RecordSet into a Script Task is returning an error.

    Question

  • I am trying to pass a RecordSet that I've retrieved into a SSIS object variable (using ADO.NET) into an Script Task.  However, the Script Task is returning an error:

    Error: Error 30009: Reference required to assembly 'System.Xml, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' containing the implemented interface 'System.Xml.Serialization.IXmlSerializable'. Add one to your project. Line 27 Columns 26-32 Line Text:         Dim myDataSet As DataSet

    Does anyone know what reference I am missing?
    Thursday, October 30, 2008 5:00 PM

Answers

All replies

  •  

    You're likely missing "System.XML" as the error states, but you could also need to add "System.Data".
    Thursday, October 30, 2008 5:45 PM
    Moderator
  • Thanks.  That was a "DUH" moment for me.  I couldn't find System.XML when looking through the references so I thought it might have been contained in another reference somewhere. 

    DUH!

    Thursday, October 30, 2008 6:10 PM
  • I'm sure you'd be surprised at how often I satart talking to someone about a problem I'm having, then I suddenly get quiet, mumble "never mind", and walk away...

    Thursday, October 30, 2008 10:23 PM
    Moderator