Error Message

• cutespn

  SSCommitted

  Points: 1669

  More actions

  March 26, 2003 at 10:32 pm

  #105455

  Hi,

  When i m trying to execute the following function i m getting

  Error Message is Invalid Procedure Call or arguement DTSSource

  '**********************************************************************

  ' Visual Basic Transformation Script

  '************************************************************************

  ' Copy each source column to the destination column

  Function Main()

  DTSDestination("acct_id") = DTSSource("Account_ID")

  DTSDestination("acct_nm") = DTSSource("Account_Name")

  DTSDestination("acct_type") = 1

  DTSDestination("acct_sts") = DTSSource("Enabled")

  Main = DTSTransformStat_OK

  End Function

  thnks in advance

  
  
  
  
  
  

  Regards,
  Sudheer 
  

  
  

  

• mhweiss

  SSCarpal Tunnel

  Points: 4284

  More actions

  March 27, 2003 at 9:50 am

  #452366

  Have you tried commenting out one line at a time and running the procedure to see which line is actually causing the error? You can do this by putting a single quote in front of the line...to reactivate the line of code, just remove the single quote.

  hth,

  Michael

  
  Michael Weiss