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

How to loop through sql and print output time
how to create a table with result set in sql server
Why Merging Empty Partition Boundaries of a Partition Functions is generating a lot of Data in the Transaction Log
I am getting Status as “Not Started” in installing setup files step while installing SQL Server 2012 Advanced edition
How to Keep Modifier ID in System Versioned Temporal Tables?
Divide by zero with power function
Using XML as a method parameter in Codefluent
SQL Server 2014 job error
SQL SERVER 2008 Select statement
How do I investigate created a table syntax in SQL?
Group BY inside a subquery
How to STOP SQL Services on multiple servers using powershell
Export database schema into XML file
Is it possible to ignore SQL table alias?
Failure to Install SQL Server Evaluation
SQL Server filtering out string but leave empty strings

Categories

HOME
ajax
jdbc
semantic-ui
boost-thread
translation
memory-leaks
visualization
apollo
dataframe
onenote-api
desktop
google-plus
ipfs
keystore
sign
react-leaflet
jacoco
postmessage
scala-native
aspell
dendrogram
uicollectionview
rhapsody
zend-framework-mvc
os161
binutils
profile
hash-collision
owl-api
blackboard
pygooglechart
websauna
pep8-assembly
getjson
rowcount
android-vpn-service
picturebox
graph-databases
ifstream
color-scheme
es-shell
active-model-serializers
twiki
web-development-server
jupyter-console
react-native-router-flux
microdata
pytest-django
rkt
w3-total-cache
nsjsonserialization
walmart-electrode
sgmlreader
jenkins-jira-trigger
spell-checking
ogre3d
crystal-reports-8.5
mercury
emoticons
communication-protocol
qos
barcode-printing
xib
multiple-file-upload
group-concat
interactive-brokers
difference
persistence.xml
optionbutton
lmfit
jericho-html-parser
visual-studio-code
ember-cli-addons
cpu-speed
ultrawingrid
dmp
node-inspector
dalekjs
eclipse-classpath
smartystreets
slick-2.0
visual-studio-addins
resgen
arbor.js
cadisplaylink
subtract
gdt
die
entity-framework-ctp5
dcpu-16
ihttphandler
nvelocity
audiostreamer
recordset
osx-leopard
hadoop-plugins
writing





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