Technical Article

Proper Case function for DTS Transformation

This VBS function will convert a string into Proper Case (i.e. This Is Proper Case) during the execution of the DTS package.  Wrap the DTSSource function with the PropCase function and the result is a Proper Case transformationexampleFunction Main()    DTSDestination("Field1") = PropCase(DTSSource("Col019"))    Main = DTSTransformStat_OKEnd Function

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2003-08-05

232 reads

Blogs

DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods

By

Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...

T-SQL Tuesday #203: Risk and Reward

By

This is timely, as I’m currently on a boat in the Adriatic taking a...

dataMinds Connect 2026 – Slides & Scripts

By

You can find the slides and SQL scripts for my session “Spice up your...

Read the latest Blogs

Forums

Alamat BCA KCP Ruko Swadaya Telp:0821°7555°651

By m4rt1n4

Telp/Wa 628217555651 Jl. Swadaya Raya No. 39 Ruko Swadaya City Square Blok 1. 11-23,...

Communication, For Incidents and Life

By Pat Wright

Comments posted to this topic are about the item Communication, For Incidents and Life

PostgreSQL psql Meta Commands: Tables

By Grant Fritchey

Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Tables

Visit the forum

Question of the Day

PostgreSQL psql Meta Commands: Tables

Which of the following psql meta commands (also called backslash or slash commands) will provide information about tables within a database?

See possible answers