• psingla

    Hall of Fame

    Points: 3840

    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

  • Koen Verbeeck

    SSC Guru

    Points: 258965

    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

  • Ed Wagner

    SSC Guru

    Points: 286985

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

  • twin.devil


    Points: 22208

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

  • Dana Medley


    Points: 6764

    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!

  • ssimmons 2102


    Points: 1634

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

  • Raghavendra Mudugal


    Points: 10658

    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.

  • RK Mandava

    SSCarpal Tunnel

    Points: 4153

    Interesting Question

  • SqlMel


    Points: 2891

    Good question.

    Thank you.

    Mel. 😎

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    Thanks for the question

  • Hany Helmy


    Points: 13488

    Definitly learned somthing new today, thanks for the question.

  • vsagg85


    Points: 434

    Guessed One right. File system task

    Another wrong , Analysis Services Execute DDL Task.

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

  • TomThomson

    SSC Guru

    Points: 104773

    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 14 (of 14 total)

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