Table Growth with Importing Text Files

[Kruznn66]

I have a large text file with over 31000 lines of data; that I want to import into Sql table called SKU. When I use the DTS Wizard to import the text file into the SKU table I continuously get the following error.

TransFormCopy ‘ DirectCopyXForm’ Conversion Error: Conversion invalid for data types on column pair 32 (Source column ‘col032’ (DBTYPE_STR) destination column ‘Lstgibo’ (DBTYPE_I4))

I have gone through and checked it with a scripting language and everything is correct. Could the problem be with importing the file be caused by a Table Growth?

How do I get this problem corrected so I can import the whole text file at once? I am a new user using the SQL Server 7.0, and would appreciate any help in the matter.

Thanks

 

[tlbroadbent]

The message says that DTS cannot convert the string column of the text file to the integer column required by the table. It appears that data type incompatibility is the problem not table growth. Add a test in the data transformation, using VB script or JScript, to check for a valid numeric value and take appropriate action when the value in column 32 is not numeric. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.