Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Convert a CHAR space to a NULL using function in DTS
Just as additional, in Oracle the default action of a RTrim on a blank field is a NULL, that would be perfect for this, but that works in SQL only when you are compatiblity model below 70. I am not stuck on this function, is somebody know another simple way to perform the same for multiple...- DavidNPD
- Post #2
- Forum: Microsoft SQL Server: Data Transformation Services
-
Convert a CHAR space to a NULL using function in DTS
I am doing a data conversion where i need to pull many fields from a SQL2000 database to another SQL 2000 database. I am using DTS activeX scripts to perform this. During the transfer I will be pulling data from various length CHAR fields to VARCHAR fields. When the source CHAR field is blank, I...- DavidNPD
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Data Transformation Services
