"dan" <dea@deamon.com> wrote in message
news:eKp63HnXEHA.1048@tk2msftngp13.phx.gbl...
> SQL Server 2000 on Windows XP.
> I try to copy data from an Excel file to a table using a DTS
Transformation
> Task.
>
> The PK of the table is CompanyID, declared int and identity.
> In Transform Data Task Properties | Options, "Enable identity insert" is
> checked.
> However, the transformation fails with the message: "Cannot insert the
value
> NULL into column 'CompanyID'; column does not allow nulls. Insert fails".
>
> What should I do?
> Thanks, Dan
>
>
>

"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:%23WN78rnXEHA.2364@TK2MSFTNGP12.phx.gbl...
> There is an article here that will explain things
>
> Problems With IDENTITY() and the DataPump task.
> (http://www.sqldts.com/default.aspx?293)
>
> --
>
> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> www.SQLDTS.com - The site for all your DTS needs.
> I support PASS - the definitive, global community
> for SQL Server professionals - http://www.sqlpass.org
> "dan" <dea@deamon.com> wrote in message
> news:eKp63HnXEHA.1048@tk2msftngp13.phx.gbl...
> > SQL Server 2000 on Windows XP.
> > I try to copy data from an Excel file to a table using a DTS
> Transformation
> > Task.
> >
> > The PK of the table is CompanyID, declared int and identity.
> > In Transform Data Task Properties | Options, "Enable identity insert" is
> > checked.
> > However, the transformation fails with the message: "Cannot insert the
> value
> > NULL into column 'CompanyID'; column does not allow nulls. Insert
fails".
> >
> > What should I do?
> > Thanks, Dan
> >
> >
> >
>
>