January 12, 2010 at 2:35 am
hi
i want to move data from sql server 2000 server from a remote machine in sql server 2005 on a local machine.
i cannot use DTS as i have no access to de remote sql server.
i tried uding bcp utility using which i created data files but when i tried to bulk insert data from these files,
some data is moved wihtout any errors while for some, it displays an error message
"Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 486, column 21 (web)."
besides bcp are there any other tools (preferably freeware) which can help me?
Kindly help.
Thanks
Quartet1
January 12, 2010 at 8:08 am
Check if the source and destination table data types are same. Also, sometimes trailing spaces or invalid characters can cause these issues and when addressed properly, you should be able to use bcp for successful data migration
HTH...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 12, 2010 at 3:15 pm
If you have no access to the remote server, how are you going to access it using BCP?
Gethyn Elliswww.gethynellis.com
January 12, 2010 at 10:46 pm
hi
my data types are same as the destination dataabse (sql server 2005) has been created using the script generated form the source database(sql server 2000)
using bcp uitlity i have exported the data into text files which i now wanna upload into the corresponding tables in sql server 2005 database.
All i have are the files that have been generated using bcp utility. but to import the data from these files, bcp utility fails giving me the error i have mentioned earlier.
SSIS in sql server 2005 allows the import but this is possible if the destination database is enlisted in the source database server list. Is it possible to import this data incase we do not know the source database credentials?
Thanks
Quartet.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply