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

2003-08-05

204 reads

Blogs

Viewing the Statistics Objects Used to Create an Execution Plan

By

Use trace flag 8666 to view the statistics objects that the optimizer used to...

A Biography Template for New Presenters

By

Presenting is difficult, and you already know that. It is also incredibly rewarding and...

Goal Progress–Feb 2021

By

I set goals at the beginning of the year, and I’m tracking my progress...

Read the latest Blogs

Forums

Problem with creating quri for alocating amount

By Deimos_farm

good day i came a cross of a problem So i have a quri...

Problem with Logic for new column

By kobinarashid

Hi guys, I have the following table DDL/DML CREATE TABLE #DailyOnHandForecast (Id INT, ItemNo_...

pivot on 2 fields

By Bruin

I'm trying to create a query that pivots on 2 fields(entity,channel) and produce a...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers