Monday, March 12, 2012 10:44 AM
I do not write script so I expect easy and understandable answer to my question.
I have installed Medscribbler software which uses SQL 2005 server to store data. I tried to import data using this software and it gives me "out of memory" error. Data file size is .5 GB and it has about 20 fields with 1600 raws. I am doing this with 1 GB RAM. I can import small files like 10 KB but when I try to import .5GB file it gives me an error.
Again I do not write script but am trying to import data for Medscribbler program.
Can someone help me with this problem? Thanks in advance.
Monday, March 12, 2012 1:24 PM
SSIS Import/Export Wizard is the best data import/export tool:
Kalman Toth SQL SERVER & BI TRAINING
- Marked As Answer by KJian_ Monday, March 19, 2012 6:25 AM
Tuesday, March 13, 2012 1:11 PMModerator
Please, could you provide more informations about your problem ?
- the full edition and version of your SQL Server
- are you using Medscribbler to do the import of your data ? If you are using the Import/Export wizard of Microsoft, a moderator will move your thread ( with your agreement ) to the Integration Services Forum or towards the SQL Server Express Forum ( if your SQL Server is an Express edition )
We are waiting for your feedback to try to help you more efficiently.
Have a nice day
PS : the only one link i found about Medscribbler is http://www.medscribbler.com/FAQ/ImportExport/
A little short as explanations
Mark Post as helpful if it provides any help.Otherwise,leave it as it is.
- Edited by Papy NormandModerator Tuesday, March 13, 2012 1:17 PM PS added