You must use an ADO.NET connection manager rather than an OLE DB or SQL Native connection manager. I just figured this out today, having run into the exact same...