Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
DTS - Multiple Step OLE DB operation generated error
The problem is in the use of & instead of +.<br>Change all & to + and the script will execute.- trigent
- Post #2
- Forum: Microsoft SQL Server: Programming
-
DTS - Multiple Step OLE DB operation generated error
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...- trigent
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
