DTS - Multiple Step OLE DB operation generated error

[trigent]

First time to use DTS. Database is msSQL Server 7.0.<br>DataSource is a CSV file.<br>DataDestination is a OLE DB table.<br>All datasource fields are copied except one field APPTDATE which contains a date in the format of YYYYMMDD.<br>The following ActiveX script will handle APPDATE:<br>Function Main()<br> DTSDestination(&quot;APPTDATE&quot = CDATE(_<br> Left(DTSSource(&quot;Col019&quot,4) & &quot;-&quot; &_<br> Mid(DTSSource(&quot;Col019&quot,5,2) & &quot;-&quot; &_<br> Right(DTSSource(&quot;Col019&quot,2))<br> Main = DTSTransformStat_OK<br>End Function<br>When the DTS package is executed the following message occurs:<br>Error at Destination for Row number 1. Errors encountered so far in this task: 1<br>Multiple-step OLD DB operation generated errors. Check each OLD DB status value, if available. No work was done.<br><br>Eliminating the ActiveX script from the package executes successfully - but without the APPTDATE field being converted to datetime format.<br><br>Thanks in advance for any information.<br><br>

 

[trigent]

The problem is in the use of & instead of +.<br>Change all & to + and the script will execute.