Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: SQLSERVER Connection

  1. #1
    Join Date
    Jan 2007
    Posts
    4

    Cool SQLSERVER Connection

    I have upgraded to the PDI 3.0.0-RC1 release and when I connect to SQL Server connections the SQL that gets generated uses the table..column syntax instead of the table.column syntax. I have tuned off the option in the connection setting to "use .. to separate schema and table" but the syntax still uses the ".." as the separator. Is there a setting that I'm missing?

    Thanks in advance for any support.

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    I know, I know!
    It should be fixed in RC2. Due next week.
    In the mean time, try these jars to update your RC1:

    http://www.kettle.be/dloads/kettle-engine-3.0.jar
    http://www.kettle.be/dloads/kettle-ui-swt-3.0.jar

    Put them in the lib/ directory of RC1.

    HTH,

    Matt

  3. #3
    Join Date
    Jan 2007
    Posts
    4

    Default

    Thanks Matt.

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.