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
206 reads
By Brian Kelley
If a technology is still viable, don’t overlook it. Don’t get caught up chasing...
By Steve Jones
It’s time for the monthly T-SQL Tuesday blog party. This month a longtime friend,...
By Steve Jones
I got a message a few months back that Microsoft was deprecating the MySQL...
Comments posted to this topic are about the item Starting to Estimate Disk Storage...
Comments posted to this topic are about the item Keep. It. Simple.
Hello, I'm trying to remove results from this sql statement where the custid like...
If I have durable memory-optimized tables, what is the starting point for estimating storage space?
See possible answers