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.
SQL replication adding additional column in the table within subscription db is safe?
Identify Queries causing space issue
updating a column using cursor having loops
What is a user session in SQL Server?
Unable to run “INSERT INTO” from Azure SQL external table
How to find foreign keys to tables which contain an arbitrary column name
SQL Server database stuck in restoring state after BACKUP LOG WITH NORECOVERY
perl, DBI, MS SQL and prepared statements
SELECT TOP N WITH TIES #scalar_value = count(*)
T-sql multiple joins [closed]
Creating a Calendar in Tableau
SQL Query to copy SharePoint list to SQL table
SQL Server : return boolean if timestamp is within 1 minute
Ssis 2012, Ssisdb Catalog And Serverstorage Protection Level Errors
access refresh / overwrite table from odbc import [duplicate]
Drop entry from query plan cache by changing the queried table