Ideas for importing a text | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Ideas for importing a text

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.

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