Post reply

Call SSIS Import Export Wizard From Insert Trigger

  • June 10, 2012 at 11:52 pm

    #275654

    Hi,

    Is it possible to call the SSIS Import Export Wizard every time an Insert Trigger is fired??

    Thanks,

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

  • June 11, 2012 at 12:16 am

    #1499152

    It's a wizard. By defination a graphical user interface designed to guide a user through a certain process.

    Why would you ever want to call that from a trigger?

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

  • June 11, 2012 at 12:44 am

    #1499161

    Koen Verbeeck (6/11/2012)

    It's a wizard. By defination a graphical user interface designed to guide a user through a certain process.

    Why would you ever want to call that from a trigger?

    Thanks for the reply Koen.

    I figured it out. I called the exe using a job and then added the job to the trigger.

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

  • June 11, 2012 at 12:46 am

    #1499164

    I haven't been told about the requirement yet. A Senior DBA just called me and asked me if there is a way. Asked me to figure out how to do it.

    I might be told the requirement now since they are sure that it can be done.

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

  • June 11, 2012 at 12:49 am

    #1499166

    If you find out the requirement, would you please post it here?

    I'm very very curious why one would want to do such a thing.

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

  • June 11, 2012 at 12:50 am

    #1499167

    Koen Verbeeck (6/11/2012)

    If you find out the requirement, would you please post it here?

    I'm very very curious why one would want to do such a thing.

    Sure thing Koen. 🙂

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

Viewing 6 posts - 1 through 5 (of 5 total)

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