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
SQL Server : select every day of a range if there are no days in a table with condition
data at the root level is invalid. line 1 for SSIS
SQL Server Installation error on Windows 10
SQL: How to Store Integer value in CASE function in sql?
Generating unique string per each row while the code doesn't exists in the another table
DACPACK sql sysdac_instances_internal missing entry
SSDT/SSIS Execute SQL Task not populating variable with query output
Anything wrong with the interval function. the way i have used it?
OPENROWSET won't accept a variable?
SQL Query - why does this return no results?
Find out which account was used to deploy stored procedure or function using T-SQL
How Make Server Name and Database Name Dynamic
I need help using SQL case statements in where clauses
Import SQL server database to HDFS or to HIVE
SQL Update statement to count hours in a shift from midnight
Send database test E-Mail exception - lock request time out period exceeded