How can I change Data?

• GivThx

  SSCommitted

  Points: 1758

  More actions

  February 7, 2002 at 1:39 pm

  #104755

  Hi, All

  I have a q for U.

  I try to change one of my columns from 1 to "Y".. I use this ActiveX script but it doesnt work.. Any idea??

  Thx in advance..

  Jay

  *********************

  Function Main()

  dim strYesNo

  Select Case DTSSource("Upd_YTD_FICA")

  Case 1

  strYesNo="Y"

  Case Else

  strYesNo=DTSSource("Upd_YTD_FICA")

  End Select

  DTSDestination("Upd_YTD_FICA")= strYesNo

  Main = DTSTransformStat_OK

  End Function

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736255

  More actions

  February 7, 2002 at 1:55 pm

  #423453

  I believe this should be

  DTSDest() = CASE DTSSOURCE = x...

  Steve Jones

  steve@dkranch.net