Hi!

I use a insert in a DTS package.
After extending the table with a field (NOT NULL) with default, I get an
error inserting data without specifing explicit data for the new field.

What's wrong?

What does the message say ?

Something like "Cannot insert NULL value into column <myCol>"

It sounds like you are expereincing not dissimilar to this

Problems With IDENTITY() and the DataPump task.
(http://www.sqldts.com/Default.aspx?293)

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Steininger, Peter" <peter.steininger (AT) ifab (DOT) uni-karlsruhe.de> wrote in
message news:%23JilKVrdDHA.2416 (AT) TK2MSFTNGP09 (DOT) phx.gbl...

OH, Oh!

My fault, ERROR in SQL.

BUt, thanks for the articel!

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> schrieb im Newsbeitrag
news:O%23QjYXrdDHA.1448 (AT) TK2MSFTNGP12 (DOT) phx.gbl...