Post reply

SSIS-Transactions

  • February 12, 2015 at 12:07 am

    #398011

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

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

  • February 12, 2015 at 1:17 am

    This was removed by the editor as SPAM

  • February 12, 2015 at 2:48 am

    #1777164

    Very interesting question, thanks.

    Got it right with a small guess.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • February 12, 2015 at 5:19 am

    #1777191

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

    Tally Tables - Performance Personified
    String Splitting with True Performance
    Best practices on how to ask questions

  • February 12, 2015 at 7:19 am

    #1777234

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

  • February 12, 2015 at 7:30 am

    #1777241

    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!

  • February 12, 2015 at 9:15 am

    #1777280

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

  • February 12, 2015 at 10:20 am

    #1777298

    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.

  • February 13, 2015 at 7:58 am

    #1777514

    Interesting Question

  • February 13, 2015 at 10:20 am

    #1777583

    Good question.

    Thank you.

    ---------------
    Mel. 😎

  • February 14, 2015 at 6:50 am

    #1777660

    Thanks for the question

  • February 15, 2015 at 1:34 am

    #1777710

    Definitly learned somthing new today, thanks for the question.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • February 17, 2015 at 1:54 am

    #1777981

    Guessed One right. File system task

    Another wrong , Analysis Services Execute DDL Task.

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

  • February 17, 2015 at 10:05 am

    #1778118

    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.

    Tom

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

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