• Comments posted to this topic are about the item SSIS-Transactions

    SQL Server DBA | MCSE SQL Server 2012/2014

  • This was removed by the editor as SPAM

  • Very interesting question, thanks.

    Got it right with a small guess.

    Need an answer? No, you need a question
    My blog at
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Nice question. It drove me outside my comfort zone. Thanks.

  • excellent question have to give a thought before answering it. Thanks for sharing

  • twin.devil (2/12/2015)

    excellent question have to give a thought before answering it. Thanks for sharing

    +1 I learned something today. Thanks for the great question!

    Everything is awesome!

  • knew one, guessed on the other, and got it wrong. Oh well.

  • Thank you for the post, interesting one. (for me, the choices were obvious by practice)

    ww; Raghu
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • Interesting Question

  • Good question.

    Thank you.

    Mel. 😎

  • Thanks for the question

  • Definitly learned somthing new today, thanks for the question.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • Guessed One right. File system task

    Another wrong , Analysis Services Execute DDL Task.

    Well good question and another chapter in my learning bank,Thanks!!!

  • Stewart "Arturius" Campbell (2/12/2015)

    Interesting question, thanks

    Instructive references used as well

    I thought the mattmattson reference was useful and instructive, but the other two are irrelevant to the question - neither says anything at all about transactions, and that's the topic of the question.

    However, it's a nice question. It's not at all surprising (and therefor not particularly interesting) that the two task types which can't support transactions properly are one that deals with file storage not database storage and one that deals with XML not atomic values, so both pretty distant from relational theory and practise, but it is something that anyone who wants to use SSIS (whih certainly doesn't include me) needs to know.


Viewing 14 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply