Jump to content

Maximun records in External Data file


Recommended Posts

Is there a maximum number of records allowed in an external data file?


I have an external data file with over 200,000 records, and I can't get all of the records to populate. If I pull out samples in a smaller file it works fine. Other wise it is inconsistant. It seams that after it gets to a certian record it fails. There is no error message, it just doesn't work.




Link to comment
Share on other sites

I don't know of any specific limit. However, it's impossible to analyze what's going wrong with your job without seeing it. You could send it to Support.


I'll also note that the ExternalDataFileEx functionality was not designed to do the same kind of "heavy lifting" in terms of merging large or complex tables of data that a true relational database system can do. It should work, but it's not going to be optimal.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...