I'm trying to load data into an Access table that has an autonumber
field. The message "There is no column object mapped to the
non-nullable column CityID in the database".

Is there a way to turn off this validation?

Try setting the ValidateExternalMetadata property of the Destination
component to FALSE.

By the way, this newsgroup doesn't seem to be dealing with SSIS issues just
yet and I would imagine that when the time comes a new newsgroup will be
launched anyway: microsoft.public.sqlserver.is
For the time being you may have more luck at
microsoft.private.sqlserver2005.dts

Regards
Jamie Thomson
Jamie.Thomson (AT) Conchango (DOT) com
http://blogs.conchango.com/jamiethom...tegory/71.aspx


"dfin" <dave.finley (AT) gmail (DOT) com> wrote

Which, by the way, is here:
http://communities.microsoft.com/new...=sqlserver2005


"Jamie Thomson" wrote:

Thanks Jamie - that worked. I'll post to the beta group next time.

Dave