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
insert large amount of AD data into SQL server using PowerShell
Do READ ONLY file groups reduce locking
importing SQL Server .bacpac file
Sql Server pivot command based on text giving null cells
Insert data in another server via linked query
Counting special characters in SQL
How to solve below scenario in ssis?
“Back Up” not appearing in SQL Server Management Studio 2016 or 17
Visual Studio 2015 Schema compare not displaying changes
Where does a Remote SSIS package actually run
Order By A Value In Another Field
How to check 'AAA' vs 'AAa' in TSQL using SQL_Latin1_General_CP1_CI_AS collation
Pentaho Kettle - CPU Utilization 100% for Table Input & Text File Output
Auto assign column value when row is created
Using clustered vs non-clustered index on large data in SQL
Store list of ids in a table cell - SQL Server