Hi, > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 15, 2002 7:51 AM > To: [EMAIL PROTECTED] > Subject: MySQL -> Win SQL2k DTS -> MySQL > > > Hello, > > Has anyone successfully implemented using a Microsoft SQL 2000 DTS > package to copy data from one mysql database into another mysql > database? I am getting some errors pertaining to 'cannot insert blob > fields'. -which they are not blob fields. I've tried this on text, > char, varchar, tinytext. > > I feel like the MyODBC driver is very limited in the data types that > it supports. >
I will look into it. Last time when I traced this, found that the DTS is not doing a correct data type mapping while converting. Let me investigate further on this today. Thanks for the info. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Venu <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
