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

copy same records with Different ParentID from Existing ParentID
Use SQL Server LocalDB with multi user over local network
How to update record based on value of next record in SQL Server 2008
Conversion failed when converting date and/or time from character string
Delphi: What's wrong with REST API based on mORMot?
it is possible to backup sql server database in runtime
remove 1st item (or any item) form multivalued parameter item list in SSRS
Import multiple Excel files to create 1 table in SQL Server 2012
SQL Server Configuration Manager won't start: WMI returns error
how to write a t-sql master procedure to catch sub procedures raised error
rsDataSetExecutionError after stored procedure update
querying nvarchar fields in a table pauses part way through
sp_executesql date “Conversion failed when converting date and/or time from character string” in specific case
Select record over date range in SQL Server
TSQL to CAML Where value IN OTHER 2010 SP list
SQL Computing a running total of an order by customer using self-join

Categories

HOME
visual-studio-2015
ember.js
dynamics-crm
vb6
rotation
warnings
angular2-routing
d
wms
google-sheets-api
automated-tests
adsense
value
apiconnect
desktop
ndis
sendkeys
medium-editor
ada
countif
azure-servicebus-queues
nmf
switching
hash-collision
metadata-extractor
ab-initio
vcard
edge-detection
fileinfo
pcre
forum
picturebox
ifstream
phpspreadsheet
redhat-datavirt
fltk
cross-entropy
dart-pub
code-composer
nashorn
react-native-router-flux
python-idle
estimation
nsjsonserialization
production-environment
gist
tiddlywiki
component-pascal
mcrypt
static-code-analysis
opencpu
unity3d-editor
barcode-printing
rsqlite
nsfetchedresultscontrolle
android-navigationview
alter
pydio
mongoose-populate
unsatisfiedlinkerror
linkageerror
mercurial-hook
clob
spatial-query
emokit
mpeg-4
distribute
apigee-baas
isml
adobe-indesign
custom-url
low-level
utf-32
code-testing
phpdocx
circos
pyjade
robospice
haskell-platform
soa-suite
snapjs
returnurl
osi
web-safe-fonts
radchart
cosm
expression-evaluation
emacs23
hashalgorithm
printing-web-page
libavformat
aio
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