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

Multiple rows to single row in Azure Data Warehouse
What actually happens when locks are acquired in SQL Server?
Dynamic query with union based on parameter
How to add column which count distinct person any city
Entity Framework not calculating count() after grouping
Excel connect to MSSQL returns Login failed for user
SQL Server query to get the details of the table where it has single column and having multiple rows
How to declare a cursor using dynamic SQL?
SSMS/SQL-Express - edit user - password field is missing
Rollback the entire package in SSIS
sameperiodlastyear only works with contiguous date selection
FileTable - file inside another file
case specific calculation based on status of a column
SQL Server returning weird affected row counts on simple query
SQL Update statement with aggregate count
"The Microsoft Jet database engine cannot open the file. It is already opened exclusively by another user, or you need permission to view its data

Categories

HOME
makefile
visual-studio-2015
converter
jsf
cntk
jar
backup
memory-leaks
angular2-directives
concourse
value
iis-7.5
schemacrawler
contact-form-7
openwrt
pjsip
finite-group-theory
symfony-forms
uisplitviewcontroller
riak
scaling
prestodb
ip-camera
url.action
explode
cronet
csh
philips-hue
badge
tampermonkey
reactiveui
superagent
devforce
strophe
entity-system
postgresql-9.2
backup-strategies
socketpair
discord.net
coreclr
parse-android-sdk
declare
active-model-serializers
restful-url
bing-translator-api
median
powermta
rich-text-editor
estimation
lumen-5.3
livescribe
udev
photography
httplib2
bettercms
efxclipse
cjson
audioqueue
slam-algorithm
mix
try-finally
lemoon
datasnap
textkit
android-snackbar
base32
mogrify
calibration
playscape
rx-groovy
ubercart
findcontrol
sysfs
sqoop2
ejabberd-saas
kallithea
belongs-to
viewflipper
x-ua-compatible
funkload
picat
sgml
zipalign
reserved-words
android-json-rpc
java.util.date
goinstant
execvp
shortcuts
digital-design
cbcentralmanager
xgettext
cosm
unions
parameterization
makefile-project
maven-ant-tasks
emacs23
nagle
chatroom

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