I'm trying to import .pdf images into our database using an "Import Column"
control.

We have a directory of images for each county in the state. I'm loading the
images from each directory with a separate run of my SSIS package. The 1st
2 sets of images, 3035 & 10314 .pdf images consecutively, loaded great.

The first load of 3035 images took about 2 minutes, the second load of
10314 images took about 7.5 minutes.

The third county directory contains 30,389 images ... the SSIS package
crunched on the 3rd directory for about 20 minutes and croaked after
importing 9916 images. The package turned the "Import Column" object red
and then stopped with the following error messages.

From what I can tell from poking around the web ...

Error: 0xC020802A - means that the file the "Import Column" object was
working on wouldn't load (duh)
0x8007000E seems to be associated with memory errors when it
appears at other application aborts.

Any help or suggestions would be greatly appreciated.

I've basically adapted the SqlIS.com example at
http://www.sqlis.com/default.aspx?305 to get things working.

Thanks in advance!

Barry
in Oregon

================================================== ===

SSIS package "to_wl_well_log_image.dtsx" starting.

Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation
phase is beginning.

Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation
phase is beginning.

Information: 0x40043006 at Data Flow Task, DTS.Pipeline: Prepare for
Execute phase is beginning.

Information: 0x40043007 at Data Flow Task, DTS.Pipeline: Pre-Execute
phase is beginning.

Information: 0x4004300C at Data Flow Task, DTS.Pipeline: Execute phase
is beginning.

Error: 0xC020802A at Data Flow Task, Import Column [33]: Reading from
the file "H:\CLAC\CLAC_198.pdf" failed with error code 0x8007000E.

Error: 0xC0209029 at Data Flow Task, Import Column [33]: The "component
"Import Column" (33)" failed because error code 0xC020802A occurred, and
the error row disposition on "output column "pdf_image" (230)" specifies
failure on error. An error occurred on the specified object of the
specified component.

Error: 0xC0047022 at Data Flow Task, DTS.Pipeline: The ProcessInput
method on component "Import Column" (33) failed with error code
0xC0209029. The identified component returned an error from the
ProcessInput method. The error is specific to the component, but the
error is fatal and will cause the Data Flow task to stop running.

Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: Thread "WorkThread0"
has exited with error code 0xC0209029.

Information: 0x40043008 at Data Flow Task, DTS.Pipeline: Post Execute
phase is beginning.

Information: 0x402090DF at Data Flow Task, OLE DB Destination [16]: The
final commit for the data insertion has started.

Information: 0x402090E0 at Data Flow Task, OLE DB Destination [16]: The
final commit for the data insertion has ended.

Information: 0x40043009 at Data Flow Task, DTS.Pipeline: Cleanup phase
is beginning.

Information: 0x4004300B at Data Flow Task, DTS.Pipeline: "component "OLE
DB Destination" (16)" wrote 9916 rows.

Task failed: Data Flow Task

Warning: 0x80019002 at to_wl_well_log_image: The Execution method
succeeded, but the number of errors raised (4) reached the maximum
allowed (1); resulting in failure. This occurs when the number of errors
reaches the number specified in MaximumErrorCount. Change the
MaximumErrorCount or fix the errors.

SSIS package "to_wl_well_log_image.dtsx" finished: Failure.

================================================== ===

Hi Customer,

Thank you for your posting.

If I understand properly, you created a package to import .pdf images to
database by using the "Import Column" control. When you ran the package on
a folder with 30,389 images the task failed after importing 9916 images.

Based on my research, the 0x8007000E error means "Not enough storage is
available to complete this operation." From the symptom, it seems that the
memory or storage space is used up when the number of image files is large.
To check whether this is the case, please perform the following tests:

1. Please separate the .pdf image folders to several small ones. Can you
run the package successfully in such an environment?
2. Can this problem be reproduced at the same .pdf file?

If you have any updates, please feel free to let us know.

Have a nice day!

Best regards,

Laura Zhang
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.

This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/tec...rview/40010469
Others: https://partner.microsoft.com/US/tec...pportoverview/

If you are outside the United States, please visit our International
Support page: http://support.microsoft.com/common/international.aspx.

================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.