I resolved this by recreating the package from scratch. I think that I had a
problem with my transformation mappings.
Joel
[quoted text, click to view] "JoelB" wrote:
> I have a DTS package that imports records from a fixed-width text file into a
> table with matching columns. There are about 500,000 records to import, but
> after "successful" completion of the package, only 288,000 records have been
> imported.
>
> I located in the text file one of the records that is not being imported,
> and deleted all of the other records, so the file contained just the one.
> Again the package runs successfully, but reports zero transactions imported.
>
> I can enter the data manually.
>
> Can someone give me some ideas for troubleshooting this thing? Without any
> errors being reported, I'm sort of at a loss for how to corner the issue.
>
> TIA,
> Joel