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))
However, I can import portion of the text file into the SKU table with no problem. Additionally, if I import the text file as a new table (SKU1) it works fine except I have no column headings except Col1, Col2 and so on. When I go to view the diagrams or create a new table it give me the following error:
An unexpected error happened during this process
How and what do I need to do to get this problem fixed. Also can you write a stored procedure (macro) in Sql that would import the data without using the DTS Wizard?
I am a new user using the SQL Server 7.0, and would appreciate any help in the matter.
Thanks,
Travis
TransFormCopy ‘ DirectCopyXForm’ Conversion Error: Conversion invalid for data types on column pair 32 (Source column ‘col032’ (DBTYPE_STR) destination column ‘Lstgibo’ (DBTYPE_I4))
However, I can import portion of the text file into the SKU table with no problem. Additionally, if I import the text file as a new table (SKU1) it works fine except I have no column headings except Col1, Col2 and so on. When I go to view the diagrams or create a new table it give me the following error:
An unexpected error happened during this process
How and what do I need to do to get this problem fixed. Also can you write a stored procedure (macro) in Sql that would import the data without using the DTS Wizard?
I am a new user using the SQL Server 7.0, and would appreciate any help in the matter.
Thanks,
Travis
