December 18, 2001 at 4:24 am
Another department have written a DTS package which uses Text File Import rather than direct DB connection (which I am used to). There is 37 rows in this text file, but the load only seems to pick up 32. The developer assures me that the file doesn't contain any 'weird' characters, so now I'm a bit stuck. Any ideas what might be the problem? This is on SQL 2000 SP1.
Thanks
Dave Francis
December 18, 2001 at 5:09 am
Maybe they have it skipping a 5 row header? I'd set the error logging on the package, see what happens. If you have VB available, save the package as VB, then step through the code in the IDE, that will give you a chance to see for sure.
Andy
December 21, 2001 at 10:28 am
Ok, I'll have a go. Thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply