I have figured this out.

The reason I could not reference the @xmldata variable was becuase I needed to declare and assign it within the dynamic sql.