BeyondBGCM
asked on
Load flat Files in Database
hi
can you please suggest me what are the fastest ways to load flat files to Database, If files size is over 1 GB.
best methods i know are
1. BCP
2. SSIS Load
do you have any more suggestions to this , which is faster and simpler.
can you please suggest me what are the fastest ways to load flat files to Database, If files size is over 1 GB.
best methods i know are
1. BCP
2. SSIS Load
do you have any more suggestions to this , which is faster and simpler.
I'm only familiar with SSIS (I have a hammer, everything looks like a nail), so I'll only speak to that.
Couple of possibilities:
1 Use a Raw File Source, which does not parse or translate the data, to optimize for speed.
2 Does this file represent a file you've loaded before, with a small subset of changes compared to the overall set? If so, consider asking the source to send you a change-only file.
Couple of possibilities:
1 Use a Raw File Source, which does not parse or translate the data, to optimize for speed.
2 Does this file represent a file you've loaded before, with a small subset of changes compared to the overall set? If so, consider asking the source to send you a change-only file.
ASKER
1. I have 150 different files
2. I have to load them one by one , each mapped to one unique table in database.
3. I can use SSIS no issues.
2. I have to load them one by one , each mapped to one unique table in database.
3. I can use SSIS no issues.
ASKER
I havent received answer to this question yet .....
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER