Hi, We have a DTS package that loads data, around 20,000 each night. This job has run happily for a number of years without issue.
Yesterday the job failed with the following error :-
Step Error Source: Microsoft Data Transformation Services Flat File Rowset Provider
Step Error Description:Invalid delimited data: text qualifier must be followed by a column delimiter (except the last column).
Step Error code: 80004005
Step Error Help File
Step Error Help Context ID:0
The environment has not changed, nor has anything on the source system. After reviewing the source file I am still unable to locate where the errror is.
Could anyone provide me with some assistance?