on 06-24-2010 2:15 AM
Hi,
I need to import 60MB file into my Application. I tried import into Fact Table as Import didn't work. Even with that I am getting the Overflow error. I tried splitting the file into 2 and later into 4. Let me know of any other suggestions as I dont want to split my file into 10 files..
Thanks
Raj
Hi,
You can increase the COMMITTIMEOUT in "Set AppSet parameter" some higher number. By default its set to 9000 secs. If the inset is more than this then it fails. Its just a parameter to increase the perfomance.
Hope it helps
Raman
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Raj,
If this is a one time activity, then you can try to load the file directly into the fact file in SQL using the import functionality of SQL.
Hope this helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.