question

patdev-3689 avatar image
0 Votes"
patdev-3689 asked Monalv-msft commented

Look up fails with large file

Hi all,

i have issue with large data load (over 100Mil) records:

OLE DB error occurred while populating internal cache. Check SQLCommand and SqlCommandParam properties

failed the pre-execute phase and returned error code 0xC020824E.

any suggestion. in full chase it fails. in partial cache it fails.

Please guide.

Thanks

sql-server-generalsql-server-integration-services
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

What are the components that you using? What are the sources and how many rows in each? If you are using a lookup component, how many rows are in the table you are looking up in? And finally, what are you trying to do with the look up?

0 Votes 0 ·

Hi @patdev-3689,

Could you please share the example data in your SqlCommand and the screenshot of components in your Data Flow Task?

May I know if you choose no cache in Lookup?

Best regards,
Mona

0 Votes 0 ·

Hi @patdev-3689 ,

May I know if you have anything to update?

Best regards,
Mona

0 Votes 0 ·

1 Answer

PranamK-0159 avatar image
0 Votes"
PranamK-0159 answered
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.