Why the square brackets around [MediaCreateCustomerDataSet] ?
They aren't generally needed unless you're using a SQL Server reserved word or have spaces in the name. Have you tried your dynamic query without them?
Sigerson
"No pressure, no diamonds." - Thomas Carlyle