October 18, 2002 at 12:01 pm
I'm importing a fixed length file using DTS. The first line is blank so in the file connection I set it to skip 1 line. I next mark column positions. Here I can see the first 5 records or so and everything looks good. When I try to import the file into my SQL table, the second line (the first one that contains data) is missing. When I run a test on my activeX transformation, the record doesn't appear hear either. The activeX only maps the field so none of that code should have any effect on skipping lines. I'm a bit at a lost since it looks like it should import but then doesn't.
The package was designed on a desktop with SQL 2K the the server it is hitting is still 7.0. (We're in the middle of upgrading to SQL 2K and this server is still a month or two out.)
Thanks,
Jason
October 18, 2002 at 5:03 pm
Sure the record delimiter is good?
Andy
October 21, 2002 at 5:07 am
What sort of task are you using. Try looking on www.sqldts.com
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
http://www.amazon.co.uk/exec/obidos/ASIN/1904347088
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
October 21, 2002 at 6:57 am
Andy: Yes, every line has a CR and LF. This was my first theory as well, but I found that everything looked good.
Simon: Data Pump. I had looked on SQL DTS but was unable to find anything useful. I also searched the KB for article but still didn't find anything.
Thanks,
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply