Error using import wizard - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

Error using import wizard

Author

Topic

mphelps
Starting Member

12 Posts

Posted - 2002-05-15 : 08:46:51

Hi All,

When using the import wizard to to import a text file with fixed field format and want to skip n number of rows. the result is that n+1 rows will be skipped if the first row in the file is shorter than the rows you are expecting to copy

example

Output file from mainframe
AC-PERIOD SCHEME MEMBER TRANDATE MDT MISC1 MISC BTCODE
199401 0000001 00000001 19940101 19940131 HGH ECS TAXRFT03
199401 0000002 00000002 19940101 19940131 HGH ECS TAXRFT03
199401 0000003 00000003 19940101 19940131 HGH ECS TAXRFT03

Solution - make the first row at least the same length as the rows to be exported

quote:
I don't suffer from insanity, I enjoy every minute of it

YellowBug
Aged Yak Warrior

616 Posts

Posted - 2002-05-15 : 16:37:23

Asseblief meneer, ek kan jou nie verstand nie

What error are you getting?
Do you just want to skip the first n rows?

mphelps
Starting Member

12 Posts

Posted - 2002-05-16 : 05:26:41

The problem is that you DON'T get an error. There appears to be a bug.

If the first row in the file is shorter than the rest as per my example, and you want to skip the first two rows, the result is that the first three rows will be skipped. You lose one row of data

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources