Is there a size limitation for an Access DB destination in SSIS?
Posted
by Adam V
on Stack Overflow
See other posts from Stack Overflow
or by Adam V
Published on 2010-05-11T14:29:31Z
Indexed on
2010/05/11
14:34 UTC
Read the original article
Hit count: 209
I'm creating an SSIS package, which will read through a user's SQL database and populate the tables in an Access database. However, for the largest user databases, I start getting errors around the time the Access file reaches approx. 2 GB.
Has anyone run into this problem? Is this a size limitation for this operation?
More information: I'm getting the error code 0xC020907B, but no additional information that I can see.
Error: 0xC0209029 at , [733]: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "input "OLE DB Destination Input" (746)" failed because error code 0xC020907B occurred, and the error row disposition on "input "OLE DB Destination Input" (746)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.
© Stack Overflow or respective owner
