Weird error running similar scripts in same pkg

[katbear]

Hello,

I have a package that has a FOREACHLOOP container. Inside the container is a SCRIPT task that runs a stored procedure and writes the output of the sp to a file.

That part works fine.

However, if I add a second script task inside the FOREACHLOOP container, I get error messages when running the second script task.

The second script task is identical to the first script task, except for the connection information. That is, it's doing the same thing, but running the sp on another server.

I tried removing the second script task from the FOREACHLOOP container, and putting it in it's own FOREACHLOOP container, but it still gives the same error.

This is the error I'm receiving:

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 7 Column 22 through 30

Private objDT As DataTable

 

[paulkeys]

Do you have the same declarations in the second script task - it looks as though you're not importing the XML Namespace

 

[katbear]

I needed to add system.xml.dll to the project references