• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Capitalization on SQL server

S

SoftwareEng

Senior member
Hey,

We have a bunch of DTS packages that copy data to SQL Server 2000. I need to find out where data gets capitalized. Can a DTS package perform capitalization on its own (via settings/parameters), or must this be done through a Stored Procedure?

(If must be done through a Stored Procedure, I can look at those and not waste time with package settings)

thanks!
 
I don't know about DTS, but SSIS has a task for such functionality. Nevertheless, Data Warehousing 101 says perform such tasks at the source, unless you're delivering real-time data (hardly seems to be true in your case; you wouldn't be using DTS otherwise 😉). So, make use of TOLOWER()/TOUPPER() when querying data - in your SPROC.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top