An OData based dataset can only be used as a "RelationalSource" in copy activity. Please see this MSDN link for details: ...