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
In the technologically driven world of 2024, more individuals are finding themselves drawn towards the...
By Steve Jones
I’m heading to Boston next week for SQL Saturday Boston 2023. I went to...
In this series of blog posts, we’re diving into how to use the Pure...
CREATE TABLE #tempdblogin ( lastcheck nvarchar(100) ) EXEC sp_MSforeachdb 'USE ? insert into #tempdblogin...
I am considering implementing an Azure Postgres DB for use in a part of...
Every time the dev team runs their dacpac, they encounter an issue. "This deployment...
Ask SSC