help

• Best-330874

  SSCrazy

  Points: 2350

  More actions

  January 3, 2007 at 7:28 am

  #76633

  i  am trying to do  a simple transformation through DTS. My source column TreatyNumber has values like MRQYP2C2 MRQYP3C2 MRQYP2C2 what i want to do is take the 6th Digit which will be a 2 in the first instance (MRQYP2C2) and put it in my destination column which is TreatyID.I need to know only how to write VB script for this transformation. '********************************************************************** '  Visual Basic Transformation Script '************************************************************************ '  Copy each source column to the destination column Function Main()  DTSDestination("TreatyID") = DTSSource("TreatyNumber")  Main = DTSTransformStat_OK End Function

  IP Logged

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738632

  More actions

  January 3, 2007 at 9:05 am

  #680981

  Please don't cross post.

  This is answered here: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=334004