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

Making a PostgreSQL Backup in a Container

By

I needed to back up a PostgreSQL database as a part of the repro...

Azure SQL offerings

By

There are three Azure SQL products with so many different deployment options, service tiers,...

T-SQL Tuesday #183 Roundup

By

I hosted this month’s T-SQL Tuesday party with my invitation asking about tracking permissions....

Read the latest Blogs

Forums

RLS Causing RBAR

By danielfountain

Hi all, First I want to ask just a generic question.  Does RLS in...

SQL2019 STANDARD max memory is 128Gb yet my Bufferpool exceeds this value

By PearlJammer1

Reading the Microsoft documentation it says SQL2019 STANDARD EDITION has a max memory of...

Having issues installing SSIS extension for VS 2022 Community

By daniel.manke

I have installed the SSIS extension for VS 2022 community. When I go into...

Visit the forum

Question of the Day

A Simple Choice

I have this data in a table?

CatIDCatName
3Monitors
What is returned when I run this code?
SELECT CHOOSE(catid, 'Laptops', 'PCs') FROM dbo.Categories AS c
 

See possible answers