I'm transfering a text data field into a varchar data
field and it sometimes takes a very long time. So, I want
to optimize this activeXscript

'************************************************* *********
' Visual Basic Transformation Script
'************************************************* *********

' Copy each source column to the destination column
Function Main()

DTSDestination("CUR_FLAG") = "C"

DTSDestination("NOTES") = DTSSource("Notes")
END IF

Main = DTSTransformStat_OK
End Function


I'm thinking about casting the text field as varchar to
see if it improves performance.
So, how do I cast or convert this text datatype to
varchar. I really don't know the vb syntax. Thanks in
advance for your help. Sandra

If you can CAST the TEXT datatype field to a varchar it begs the Q. "Why is
it not a varchar to begin with ?"

the VB func to convert to a string is Cstr()


--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Sandra" <silvah (AT) wellsfargo (DOT) com> wrote