SSIS Visual Studio

I am having a problem developing a SSIS package in Visual Studio and SQL Server 2005 Enterprise Edition.

Validation is happening after I have set ValidateExternalMetadata = FALSE causing and error

My package writes to a SQL Server table with a handfull of rows and columns using OLE DB destination.

One of the columns in the table is a 'NOT NULL' data type.

I have a trigger on the table handling any null condition. (see below)

(I know the trigger works because I have tested it by inserting rows manualy within SQL Server Mgnt Studio)

When I €œExecute Package€? (DEBUG) my data flows through till the OLE DB destination, which turns red, errors out, and does not attempt to write the data !!! !!!

Ideas, suggestions ??

My next step is to develop a work around so that Visual Studio and SQL Server 2005 Enterprise Edition SSIS will write the data and not error out.

Thanks




Trigger:
CREATE TRIGGER [dbo].[dim_ins]
ON [dbo].[rollup_dim]
AFTER INSERT
AS
BEGIN
update rollup_dim
set str_link_id = str_id
where str_link_id is null;
END