I'm confused. I've got on OLE DB Destination set up to insert records into a table in an SSIS package.
The table contains three columns:
[LoginID] [int] IDENTITY(1,1) NOT NULL,
[UserName] [varchar](60) NOT NULL,
[FullName] [varchar](118) NULL,
There Input Column for LoginID is set to <ignore>. That is, I am relying upon the fact that this is an IDENTITY column to set it's value. Yet, when it tries to do an insert, the insert fails with the following error.
"Cannot insert the value NULL into column 'LoginID', table 'SDE.dbo.SDELogin'; column does not allow nulls. INSERT fails."
I have used different Data access modes, to no avail.
If I do an INSERT through SSMS, then the record is inserted without error. Any help will be much appreciated.