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 / .NET - Get the connection pool size
Amazon RDS SQL Server Change Database Owner
Convert Access query into SQL Server stored procedure
How to Add Entity Without Recreating Tables
SQL Server TOP constraint [closed]
How to convert 71632.0638353154 to 71,632.06 in SQL Server and SYBASE?
I want to fetch autoincremented varchar values from SQL Server 2008
Copy and paste excel to sql server table
C#.net Console Application SQLCommand.CommandTimeOut property not working
Is there a limit to the number of Common Table Expression (CTE) expressions allowed?
Lightswitch : can it create a real time SQLServer DB Monitoring application?
Most Efficient Many-To-Many Linq Query
Repeated Name/Password Requests Using MS Access 2003 and SQL Server 2008
Why does a query using a parameter return no rows when the same query with constants returns 122K
sp_send_dbmail is not working
CROSS APPLY Style versus Performance