would someone help with here please... I'm creating an Employee dim table combining employee, EmployeeTerritories, Terriritories, and Region tables. I'm my SSIS OLE DB Destination, i get an error "Failure inserting into read-only EmployeeID" yet my table has no constraints at all. Thank you people, ghhf

could you paste script of your destination table here? http://www.rad.pasfu.com

CREATE TABLE [dbo].[Employees]( [EmployeeID] [int] IDENTITY(1,1) NOT NULL, [TerritoryID] [nvarchar] (20) NOT NULL, [TerritoryDescription] [nchar] (50) NOT NULL, [RegionID] [int] NOT NULL, [RegionDescription] [nchar] (50) NOT NULL, [LastName] [nvarchar] (20) NOT NULL, [FirstName] [nvarchar] (10) NOT NULL, [Title] [nvarchar] (30) NULL, [TitleOfCourtesy] [nvarchar] (25) NULL, [BirthDate] [datetime] NULL, [HireDate] [datetime] NULL, [Address] [nvarchar] (60) NULL, [City] [nvarchar] (15) NULL, [State] [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, [PhotoPath] [nvarchar] (255) NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO ghhf

Please let us know how EmployeeID is defined, it might the culprit.Arthur My Blog

i think i got it. i had identity on employeeIDghhf

problem is IDENTITY , in the OLEDB Destination check the Keep IDENTITY and try again ( also you should try "table or view - fast load" as access mode too )http://www.rad.pasfu.com

If EmployeeID is an IDENTITY column, you can't insert into it, unless you enable IDENTITY_INSERT.John Welch | www.varigence.com | www.agilebi.com | ssisUnit.codeplex.com

thank you pleaseghhf