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 replication adding additional column in the table within subscription db is safe?
Identify Queries causing space issue
updating a column using cursor having loops
What is a user session in SQL Server?
Unable to run “INSERT INTO” from Azure SQL external table
How to find foreign keys to tables which contain an arbitrary column name
SQL Server database stuck in restoring state after BACKUP LOG WITH NORECOVERY
perl, DBI, MS SQL and prepared statements
SELECT TOP N WITH TIES #scalar_value = count(*)
T-sql multiple joins [closed]
Creating a Calendar in Tableau
SQL Query to copy SharePoint list to SQL table
SQL Server : return boolean if timestamp is within 1 minute
Ssis 2012, Ssisdb Catalog And Serverstorage Protection Level Errors
access refresh / overwrite table from odbc import [duplicate]
Drop entry from query plan cache by changing the queried table

Categories

HOME
cakephp-3.x
sass
crate
puzzle
wsdl
nuxeo
docker-swarm
zend-framework2
apple-numbers
terrain
rebol
snap.svg
devstack
sudo
eval
openwrt
jboss-eap-7
wordpress-theming
activesync
cosmicmind
datagrip
bootstrap-popover
android-toolbar
arraylist
embedly
jquery-form-validator
os161
tcpclient
binutils
header-files
reply
idl
pljson
division
nsurlconnection
socketpair
poco-libraries
code-behind
concrete5-5.7
viewgroup
knockout-3.0
xbim
pytest-django
rkt
z3py
dojox.grid.datagrid
persistent
spring-data-hadoop
maintenance
info
uicollectionviewlayout
qos
rxvt
payu
push-diffusion
galleriffic
pagekit
gherkin
gemini
persistence.xml
wikitext
visual-studio-code
type-mismatch
sparse-file
bridge
candidate-key
collabnet
sortable
node-imagemagick
ghostdoc
sthttprequest
ifft
visual-c++-2010-express
bfd
fogbugz-api
ruboto
html-form-post
nuspec
resgen
tridion2009
bulbs
cadisplaylink
datarepeater
visual-web-gui
ubuntu-11.04
emacs23
django-nose
port-scanning
pureftpd
j-interop
hardware-acceleration
iphone-sdk-3.2
openwysiwyg
interface-design





Mobile Apps Dev
Database Users
javascript
java
csharp
php
android


MS Developer
developer works
python
ios
c
html
jquery


RDBMS discuss