Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004
    Posts
    64

    Question Unanswered: "requested conversion is not supported" error in DTS data copy.

    I have a DTS that pulls data in from a table in MysQL and inserts it into a tablle in SQL Server. it's failing when I run the step with the "requestd conversion is not supported" error, but when testing each single column copy in the Data Transformation step, it passes.

    I just want an exact copy of the data.


    the source MySQL table is....

    CREATE TABLE `entry` (
    `web_id` int(11) NOT NULL auto_increment,
    `web_name` varchar(40) NOT NULL default '',
    `web_email` varchar(60) NOT NULL default '',
    `web_cli` varchar(50) NOT NULL default '',
    `web_pu_id` varchar(60) default NULL,
    `web_answer` varchar(60) NOT NULL default '',
    `web_ddi` varchar(30) default NULL,
    `web_time_entered` datetime NOT NULL default '0000-00-00 00:00:00',
    `web_ip_address` varchar(20) default NULL,
    `web_entry_status` set('failed','success') NOT NULL default '',
    `web_polled` enum('true','false') default 'false',
    PRIMARY KEY (`web_id`)
    ) ENGINE=MyISAM;

    and the SQl Server destination is....

    CREATE TABLE [entry] (
    [web_id] [int] NOT NULL ,
    [web_name] [varchar] (23) NOT NULL ,
    [web_email] [varchar] (37) NOT NULL ,
    [web_cli] [varchar] (15) NOT NULL ,
    [web_pu_id] [varchar] (15) NULL ,
    [web_answer] [text] NOT NULL ,
    [web_ddi] [varchar] (11) NULL ,
    [web_time_entered] [datetime] NOT NULL ,
    [web_ip_address] [varchar] (15) NULL ,
    [web_entry_status] [varchar] (15) ,
    [web_polled] [varchar] (15) NULL
    ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
    GO

    ALTER TABLE [temp_webentry] WITH NOCHECK ADD
    CONSTRAINT [PK_tmpwebentry] PRIMARY KEY CLUSTERED
    (
    [web_id]
    ) ON [PRIMARY]
    GO

    sample line of data ...

    352711, 'some name', 'email@addre.ss', '0123456789', 'AA_XX-Y-012345-2', '', '098765432', '2005-10-19 23:17:42', '192.168.28.165', 'failed', 'false'

  2. #2
    Join Date
    Sep 2004
    Posts
    64
    scratch that.. in compairing the DDLs it was obvious..

    varchar -> text doesn't work well

    a

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •