January 29, 2008 at 9:31 am
I'm trying to import a flat file into a sql server 2005 database. I have used this flat file to load into sql server 2000 database previously with no problem. Basically my problem now is that the table that I'm loading
to has columns that are all integers. The flat file is all strings. In sql server 2000 if the flat file column was defined as a string and it contained spaces it would be converted into the perspective table column as a null. Now with the advent of SQL SERVER 2005, you receive
a type cast error. I've even tried changing in the import wizard the flat file column datatype to an integer. Then it will run successfully, however, it will supply the column with a zero when the flat file column is
really spaces. Any assistence would be greatly appreciated.
January 30, 2008 at 4:07 am
Workaround:
You can use SSIS and transfer table from SQL Server 2000 to SQL Server 2005 instead of text file.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply