Groups | Blog | Home
all groups > sql server dts > september 2007 >

sql server dts : Records not importing, but no error



JoelB
9/10/2007 11:14:06 AM
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
JoelB
9/10/2007 1:22:03 PM
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]
AddThis Social Bookmark Button