I have a SQL Server table that I want to export from one SQL Server database to another SQL Server database. I&#039;m getting an error Invalid Character value for cast specification. The tables are identical (both field names and datatypes).<BR>Question 1) What does this error mean?<BR>The database has 55 million records so I can&#039;t get to the row that is causing the error because my system runs out of memory with such a large result set when I use Go To Row command<BR>2) How can I import in smaller chunks? I don&#039;t know how to do this!! I assumed using a query and writing a SQL statement but I don&#039;t know how I would write this.<BR>Any help appreciated.<BR>