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]
SQL Server 200 SP2
How about you ?
On Thu, 18 Jul 2002 10:16:30 -0700, "Alex Ponce"
>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.