Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: mssql bit() size conversion using spoon

  1. #1
    Join Date
    Nov 2015
    Posts
    6

    Question mssql bit() size conversion using spoon

    using spoon

    trying a tranformation in which in "select values", I have a microsoft sql field with a bit() data type but when it goes through spoon into a mysql bit() field i receive a message saying that the input data is too large for the output table.

    Any thoughts?

    Thanks

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    The MySQL bit datatype doesn't seem to be the best dataype to catch a MSSQL bit which essentially is a Boolean value.
    Might be helpful to know how you tried to write to the MySQL table - Table-Output doesn't support bit fields, I think.
    So long, and thanks for all the fish.

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.