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

insert large amount of AD data into SQL server using PowerShell
Do READ ONLY file groups reduce locking
importing SQL Server .bacpac file
Sql Server pivot command based on text giving null cells
Insert data in another server via linked query
Counting special characters in SQL
How to solve below scenario in ssis?
“Back Up” not appearing in SQL Server Management Studio 2016 or 17
Visual Studio 2015 Schema compare not displaying changes
Where does a Remote SSIS package actually run
Order By A Value In Another Field
How to check 'AAA' vs 'AAa' in TSQL using SQL_Latin1_General_CP1_CI_AS collation
Pentaho Kettle - CPU Utilization 100% for Table Input & Text File Output
Auto assign column value when row is created
Using clustered vs non-clustered index on large data in SQL
Store list of ids in a table cell - SQL Server

Categories

HOME
arrays
sharepoint
laravel-5
elixir
facebook-graph-api
apollo
xtext
ext.net
tumblr
proguard
requirejs
ng-admin
octopus-deploy
x11
nixos
game-maker-studio-1.4
spring-cloud-config
dendrogram
eclipselink
sensu
k2
explode
azure-servicebus-queues
tampermonkey
ui5
spring-data-neo4j
owl-api
thinking-sphinx
cortex-m3
pitest
bxslider
svnkit
smart-mobile-studio
m2e
geopy
modelandview
sidr
pace
xen
sonarqube-scan
magiczoomplus
ssh.net
viewgroup
excel-interop
ttcn
resuming-training
ivona
prototypejs
nsjsonserialization
crystal-reports-8.5
fedora20
infinite-scroll
search-box
coremidi
gradle-script-kotlin
backstop.js
windows-azure-pack
picasa
cron-task
kendo-combobox
squirrel
financial
cctray
jenkins-scriptler
app.xaml
kendo-menu
oai
abas
twython
manjaro
xaml-designer
uptodate
jython-2.7
low-level
symfony-2.6
proximity
mser
hidden-field
ogr2ogr
smartystreets
ssms-addin
phpdocx
db4o
real-time-updates
confusion-matrix
cdata
nimrod
jqmobi
multiple-login
qtgui
vertical-scrolling
cgpath
maven-ear-plugin
usn
parameterization
responsetext
selectonemenu
nssavepanel
nemerle
qtembedded
dashcode
osx-leopard
oggvorbis
lazy-c++
self-reference
document-library

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