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
Multiple rows to single row in Azure Data Warehouse
What actually happens when locks are acquired in SQL Server?
Dynamic query with union based on parameter
How to add column which count distinct person any city
Entity Framework not calculating count() after grouping
Excel connect to MSSQL returns Login failed for user
SQL Server query to get the details of the table where it has single column and having multiple rows
How to declare a cursor using dynamic SQL?
SSMS/SQL-Express - edit user - password field is missing
Rollback the entire package in SSIS
sameperiodlastyear only works with contiguous date selection
FileTable - file inside another file
case specific calculation based on status of a column
SQL Server returning weird affected row counts on simple query
SQL Update statement with aggregate count
"The Microsoft Jet database engine cannot open the file. It is already opened exclusively by another user, or you need permission to view its data