Very Computer

I've been having lots of difficulties importing a memo
field into a SQL Server 2000 table. Since I need to
automate the process (it's not a one time thing) my
initial solution was to schedule a DTS package. I'm can
accomplish this with the exception of a memo field that is
contained on the Access source table. The DTS gives me
an "Unknown Error" regardless of the SQL table data type
that I relate the memo field to (varchar, text, nvarchar).
I've tried adding an ActiveX transformation that creates
an ADO connection to the databases but I simply don't have
access to the memo field. I get an error everytime.

Any help will be greatly appreciated.

AP

Quick test

Load the Employee table from the Northwind sample mdb

CREATE TABLE [dbo].[Employees] (
        [EmployeeID] [int] NOT NULL ,
        [LastName] [nvarchar] (20) NOT NULL ,
        [FirstName] [nvarchar] (10) NOT NULL ,
        [Title] [nvarchar] (30)  NULL ,
        [TitleOfCourtesy] [nvarchar] (25)  NULL ,
        [BirthDate] [smalldatetime] NULL ,
        [HireDate] [smalldatetime] NULL ,
        [Address] [nvarchar] (60) NULL ,
        [City] [nvarchar] (15) NULL ,
        [Region] [nvarchar] (15) NULL ,
        [PostalCode] [nvarchar] (10) NULL ,
        [Country] [nvarchar] (15) NULL ,
        [HomePhone] [nvarchar] (24) NULL ,
        [Extension] [nvarchar] (4) NULL ,
        [Photo] [image] NULL ,
        [Notes] [ntext] NULL ,
        [ReportsTo] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

SQL Server 200 SP2

Works fine.

How about you ?

Allan

On Thu, 18 Jul 2002 10:16:30 -0700, "Alex Ponce"