Run DDL Task failed when I try to BeginTransaction in it

Just try this:

1.Create a AS Connection Manager in a package, put the RetainSameConnection property into True.

2.Drag a Run DDL Task, and use the Connection in step1.

3.write the DDL query as this:

<Command>
<BeginTransaction />
</Command>

4.Run the package.

Result: It said a mistake like this:

Error: the element Command at 7 row, 38 column(Namespace urn:schemas-microsoft-com:xml-analysis) can not be displayed under Envelope/Body/Execute/Command.

Please help me, what's the hell of this?

Thanks.

Help,Help!

Thanks!

|||

Help, need help!

|||Help! Really need your help!!!|||

Can you provide some more information? what have you tried to debug.

did you try here?

http://www.topxml.com/MS-XML-Analysis/rn-219188_How-to-format-a-NotifyTableChange-command.aspx

what does your XML tag and attribute look like at 7 row, 38 column? can you post it?

|||

Thanks, but I dount that it's no business about the XML tag and attribute.

I think perhaps we just CANNOT BeginTransaction in a DDL task.

Please have a try like what I did, you will get the same result, I belive.

Thanks!

|||

Please save me!

Thanks, I am knocked down by this problem.