sql-server
Currency datatypes in Pentaho Kettle to load to MS SQL Server
What is the best way to handle currency fields using Pentaho Kettle when the end-goal is to load the data into MS SQL Server? MS SQL Server has a "money" data type, but this isn't available in Pentaho. I could convert the column to a string, and then strip out the currency symbol before loading as some sort of floating decimal numeric data type, but that seems manual and I would guess that Pentaho has more sophisticated built in capabilities. Thanks.
Related Links
copy same records with Different ParentID from Existing ParentID
Use SQL Server LocalDB with multi user over local network
How to update record based on value of next record in SQL Server 2008
Conversion failed when converting date and/or time from character string
Delphi: What's wrong with REST API based on mORMot?
it is possible to backup sql server database in runtime
remove 1st item (or any item) form multivalued parameter item list in SSRS
Import multiple Excel files to create 1 table in SQL Server 2012
SQL Server Configuration Manager won't start: WMI returns error
how to write a t-sql master procedure to catch sub procedures raised error
rsDataSetExecutionError after stored procedure update
querying nvarchar fields in a table pauses part way through
sp_executesql date “Conversion failed when converting date and/or time from character string” in specific case
Select record over date range in SQL Server
TSQL to CAML Where value IN OTHER 2010 SP list
SQL Computing a running total of an order by customer using self-join