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 : select every day of a range if there are no days in a table with condition
data at the root level is invalid. line 1 for SSIS
SQL Server Installation error on Windows 10
SQL: How to Store Integer value in CASE function in sql?
Generating unique string per each row while the code doesn't exists in the another table
DACPACK sql sysdac_instances_internal missing entry
SSDT/SSIS Execute SQL Task not populating variable with query output
Anything wrong with the interval function. the way i have used it?
OPENROWSET won't accept a variable?
SQL Query - why does this return no results?
Find out which account was used to deploy stored procedure or function using T-SQL
How Make Server Name and Database Name Dynamic
I need help using SQL case statements in where clauses
Import SQL server database to HDFS or to HIVE
SQL Update statement to count hours in a shift from midnight
Send database test E-Mail exception - lock request time out period exceeded

Categories

HOME
xbox-live
google-apps-script
udp
project-management
uibutton
visual-studio-2013
backup
mainframe
propertygrid
algorithmic-trading
filter
tumblr
jpanel
vsftpd
gimp
openwrt
slim-3
height
unity2d
criteria
intellij-plugin
scaling
rhapsody
ng-show
jpeg2000
clover
cruisecontrol.net
countif
os161
rworldmap
delete-file
iis-10
croppic
net-snmp
branch
widevine
winscp
dd-wrt
blackboard
ipfw
npm-shrinkwrap
rhino
pox
socketpair
coreclr
parse-android-sdk
agent
tic-tac-toe
infusionsoft
wcf-security
floating-accuracy
ical-dotnet
nsjsonserialization
amazon-machine-learning
livescribe
shutdown
spring-data-hadoop
struts-layout
search-box
jszip
collapsingtoolbarlayout
ingres
gulp-typescript
settimeout
packagemaker
glkit
rstudio-server
tuxedo
pax-web
clob
fortran90
cmocka
anythingslider
direct3d12
site-prism
lmfit
rad
registrykey
response-headers
qbfc
ipojo
debian-based
hg-git
multipleselection
python-ggplot
cpu-speed
ultrawingrid
ember-components
bsp
late-static-binding
ksoap2
sanitization
gamepad
cdata
image-zoom
sttwitter
html-form-post
sequelpro
maven-ear-plugin
osi
vim-powerline
tfs-power-tools
z-machine
shared-objects
testunit
exitstatus
multibyte-functions
act
internals
economics
standardized

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