Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Insert Data Into SQL Server Table

  1. #1
    Join Date
    Jul 2009
    Posts
    3

    Default Insert Data Into SQL Server Table

    Hi

    What is the best transformation step to use to insert data into a SQL Server Table from a Table input step where there are no matching keys?

  2. #2
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    http://wiki.pentaho.com/display/EAI/...on+v3.2.+Steps

    Might help...

    The step you want is likely the Table Output step. I assume you are talking about MS SQL server. If you are using a Postgre SQL server, there's an experimental Bulk Loader.

  3. #3
    Join Date
    Jul 2009
    Posts
    3

    Default Insert Data Into SQL Server Table

    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.