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

205 reads

Blogs

Using Data Masker on Chinese Surnames

By

A customer had a question recently on masking Chinese characters. I thought that was...

A New Word: Looseleft

By

looseleft – the feeling of loss upon finishing a good book, sensing the weight...

Using ChatGPT for Writing

By

I have been experimenting more and more with ChatGPT on a regular basis. I’m...

Read the latest Blogs

Forums

NOT LIKE Alternatives in WHERE clause

By BOR15K

Hello, I need help to improve an existing (hence I cannot change table's structure...

Vulnerability Assessment removed?

By cgumprich

In Brent Ozar's list of links today, I learned that Microsoft has removed the...

Advanced SQL query help

By sc-w

Hi, I am looking for some help with two queries using the following table/data....

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers