How to execute sql command after import tool finished import

 
1
0
-1

I configured one import tool and want to execute insert command after import action completed. I used  the trigger which insert data when insert or update, but when I import data, import tool will be endless loop within the trigger. How could I execute sql command after import tool finished import ? As my import action is not regular, so I can't set schedule job on SQL server.

    CommentAdd your comment...

    2 answers

    1.  
      1
      0
      -1

      if you are using a userview, make a process including database update tool and put its URL on redirection property of import menu

        CommentAdd your comment...
      1.  
        1
        0
        -1

        You are using import tool in a process or in a post processing tool of the form. right??

        Insert another tool (database update tool) after the import tool and write your query

        1. Marcus Huang

          Oh, sorry. It's my mistake. It's import menu in userview, not import tool in form or process. So I can't set a tool any more.

        CommentAdd your comment...