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 / .NET - Get the connection pool size
Amazon RDS SQL Server Change Database Owner
Convert Access query into SQL Server stored procedure
How to Add Entity Without Recreating Tables
SQL Server TOP constraint [closed]
How to convert 71632.0638353154 to 71,632.06 in SQL Server and SYBASE?
I want to fetch autoincremented varchar values from SQL Server 2008
Copy and paste excel to sql server table
C#.net Console Application SQLCommand.CommandTimeOut property not working
Is there a limit to the number of Common Table Expression (CTE) expressions allowed?
Lightswitch : can it create a real time SQLServer DB Monitoring application?
Most Efficient Many-To-Many Linq Query
Repeated Name/Password Requests Using MS Access 2003 and SQL Server 2008
Why does a query using a parameter return no rows when the same query with constants returns 122K
sp_send_dbmail is not working
CROSS APPLY Style versus Performance

Categories

HOME
tensorflow
vhdl
angular2-routing
visualization
zend-framework2
terrain
adsense
rebol
xtext
devstack
docker-windows
actionscript-2
wicket
spinnaker
flann
x-frame-options
titan
opera-mini
arm-template
boolean-expression
mousewheel
prediction
fabric
auditing
pentaho-report-designer
system.data.sqlite
google-api-dotnet-client
positioning
encase
pljson
phpspreadsheet
pox
xen
wfp
office365connectors
concrete5-5.7
agent
equivalence
wsadmin
dart-pub
sendgrid-templates
scalafx
apiary
worker
archer
timesten
appstore-approval
gist
component-pascal
tofixed
nuget-server
sqlexception
inject
master
picasa
aescryptoserviceprovider
bacnet
brython
listadapter
usb-drive
eml
insertion-sort
throughput
mirrorlink
uialertview
manjaro
pyopengl
divide-by-zero
bridge
pylearn
robocode
musl
ticket-system
cloudpebble
outline
sthttprequest
alertifyjs
json-patch
nsmatrix
jqmobi
stagefright
attachevent
returnurl
scrollto
pstree
macruby
objectbrowser
selectmanycheckbox
curljs
testunit
ets
email-spec
gwt-2.2-celltable
oggvorbis
openwysiwyg
odbc-sql-server-driver
project-lifecycle
interface-design

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