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

Matrix-like comparison of two query results
MICROSOFT SQL Server Enterprise Core Edition - How many licenses do I need for a 96 core server? [closed]
SQL Server Agent user/password login for network
Is DROP CONSTRAINT of default values a size of data operation
why does getdate returns 1\1\1900
Connected two PC's with ethernet cable but not able to access SQL Server from other machine using Management Studio
How to resolve Azure data Migration blocker User: has an unresolved reference to Login
sql spatial search, find coordinates on a route in certain radius
SSMS: Database could not be detected as it is linked. Make sure that the user has linked a database to source control
Pivot query in SQL Server
Dynamic flat file connection string in SSIS
Singelton cluster in K-means sql server ssas
How to use the hierarchyid type of SQL Server in petapoco?
LIMIT not working in SQL
Remove some characters from string sql [duplicate]
Narrowing down results

Categories

HOME
paypal
cakephp-3.x
cntk
cluster-computing
mql4
websphere
warnings
facebook-graph-api
jasmine
avro
chaiscript
is-empty
flyway
branch.io
defragmentation
simpy
cockroachdb
wordpress-theming
gatsby
finite-group-theory
cratedb
ssms-2016
aptana
jcl
ms-access-2007
clover
backpropagation
scalaz7
richfaces
rworldmap
restfb
spring-test
pdfsharp
continuous-deployment
lync-2013
dss
blackboard
referenceerror
canvasjs
pljson
geopy
fabric-digits
openpgp
rider
.net-assembly
socketpair
freetts
active-model-serializers
stereo-3d
constants
spring-bean
jdbi
drawingarea
amazon-machine-learning
struts-layout
volume
pspice
sql-server-administration
master
spark-cassandra-connector
jackson-databind
shipitjs
mpeg-4
usb-drive
difference
wif
castle-windsor-3
on-duplicate-key
pylearn
apache-mina
shift-jis
word-2013
python-ggplot
belongs-to
gyroscope-framework
microblaze
odftoolkit
and-operator
proxies
bsp
planetary.js
indexing-service
late-static-binding
anjuta
opendata
robospice
stagefright
ftp4j
surveyor-gem
shiva3d
wpdb
trailing-slash
sequelpro
getusermedia
z-machine
serp
msbuildextensionpack
adsl
server-error
recordset
clients
evb
usergroups
divx
document-library
dotproject

Resources

Mobile Apps Dev
Database Users
javascript
java
csharp
php
android
MS Developer
developer works
python
ios
c
html
jquery
RDBMS discuss
Cloud Virtualization
Database Dev&Adm
javascript
java
csharp
php
python
android
jquery
ruby
ios
html
Mobile App
Mobile App
Mobile App