SQL Server Performance

Ideas for importing a text

Discussion in 'SQL Server DTS-Related Questions' started by rcatiggay, Mar 21, 2005.

  1. rcatiggay New Member

    I created a DTS package that reads from a text file and inserts data into a table. We recieve these text files from an outside source. The package has been working great for the past month but is now failing.

    What I discovered between the files that work and one that don't is that the ones that fail have a blank line at the end of the text file. In order words the txt file does not end at the end of the last record there is a carriage return then a blank line.

    Besides going back to the outside source to tell them not to have anyblank lines at the end of the file. Are there other options I can do with the DTS package to avoid this from happening?

    Any suggestion or ideas would be greatful.
  2. DBA_Newbie New Member

    Hi,

    Did you try re-building the transformations ? If not, may be you can give it a try.


Share This Page