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

208 reads

Blogs

Secure Azure SQL Server Backups Using Managed Identities

By

I do believe most people know about the ability to backup your SQL server...

Using a Local Large Language Model (LLM): Interacting with Local LLMs Using PowerShell

By

As AI continues to evolve, many of us are looking for ways to leverage...

Monday Monitor Tips: Finding the Hostname for Queries

By

I was chatting with a customer recently and they wanted to know which host...

Read the latest Blogs

Forums

Internationalisation

By julian.fletcher

Quick one I hope in case I'm heading off in entirely the wrong direction!...

Size of DB on physical disk doesn't match Disk Usage by Table report

By water490

Hi everyone I am looking at the size of my db on disk (ie...

Getting the TEXTSIZE

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Getting the TEXTSIZE

Visit the forum

Question of the Day

Getting the TEXTSIZE

How can I check what value I used for TEXTSIZE? I ran this code:

SET TEXTSIZE 8096
But then deleted the code and couldn't remember. Is there a way to check this?

See possible answers