Working on executing a DTS package from ADP. Using the VB file generated by enterprise manager, importing that into an ADP module. Reference thread958-848668
The package picks up a flat file on C:\ and appends it to an existing table on the server. The process executes but terms with the error "...DTS Data Pump. Column name...was not found."
My issue is that the column appears both in the source file (first row is column names; tab delimited) as well as the destination table...so I'm not so sure where it is going awry.
Anyone encounter and how was it resolved? Some quiry syntax?
Thanks
The package picks up a flat file on C:\ and appends it to an existing table on the server. The process executes but terms with the error "...DTS Data Pump. Column name...was not found."
My issue is that the column appears both in the source file (first row is column names; tab delimited) as well as the destination table...so I'm not so sure where it is going awry.
Anyone encounter and how was it resolved? Some quiry syntax?
Thanks