Filegroup is Full - During Import Data

Hi,

I am getting below error while importing data in SQL 2005 Express:

"error 0xc0202009: Data Flow Task: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Could not allocate space for object 'dbo.HistoryLog'.'PK_HistoryLog' in database 'HistoryData' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.".
"

I have select :

Enable Autogrownth = Yes

Filegrowth = 1 MB

Maximum File Size = Unrestricted File growth

I don't know what else I am missing?

Please help

thanks

AA

How much empty space was on the disk when you received the error message.

Check the Log files.

|||

there is only one Log file by the name of "HistoryData_log"

Initial size is: 1,747

Enable Autogrownth = Yes

Filegrowth = 10%

Maximum File Size = Unrestricted File growth

Empty Space on C: is 149 GB

Total database Size : 5843.00 MB

Space Available : 128.21 MB

Please note:

I just noticed when I was increasing initial database size:

"Create Database Or Alter DataBase failied becasue the resulting cumulative database size would exceed your licence limit of 4096 MB Per Database"

Please advsie is this the licencing issue?

Thanks

|||

I meant to look in the computer application logs. However, you 'stumbled' upon an explanition.

Yep, You have SQL Server Express, and SQL Server Express is limited to a maximum 4 GB database size.

|||

Is there any way to increase it?

Please advise which version is good for unlimited data base space?

Thanks for your help

Amir

|||

Any Edition you purchase, from Workgroup to Enterprise, has 'unlimited' database size.

Check here for the best Edition for your needs.

SQL Server 2005 Features, Version Comparison
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

|||Thanks for hep Arnie.

file import to SQL Server 2000

Hi all,

I have a file with an extension of .sdf. I "believe" it is a text file
of some sort but I am uncertain. The source agency hasn't returned any
of my calls so I'm wondering if anyone is familiar with this extension?
I'd like to import the file into my database - when I use DTS and chose
a text format, regardless of what delimiter I choose, the format is
still really ugly. when I pull it up in a huge text editor, it is hard
for me to tell what it is there.

I saw in one of my searches that it could be a comma delimited (it's
not) .. could be a unisys file? I know it's not much information to go
on - but where should I start in trying to get this into my database
without knowing the format? Any suggestions would be greatly
appreciated.

Thanks!
Bethany

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!A google search turned up

SDF = Windows SQL CE-version internal databases
SDF = MDL Isis SDF chemical modeller input file
SDF = Mime: application/e-score
SDF = Mime: chemical/x-mdl-sdf
SDF = Source Definition File (Sourcer)
SDF = System Data Format file (fixed lenght ascii text)

> know it's not much information to go on -
> but where should I start in trying to get this into my database
> without knowing the format?

All you can do is make assumptions and try to identify the file format via
trial-and-error. You might get help with identifying/eliminating SQL CE
from the microsoft.public.sqlserver.ce.

Once you've positively identified the file format, you can take steps to
either import directly or at least transform data into an intermediate
format suitable for import.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Bethany Holliday" <bhollida@.iupui.edu> wrote in message
news:418a7210$0$14507$c397aba@.news.newsgroups.ws.. .
> Hi all,
> I have a file with an extension of .sdf. I "believe" it is a text file
> of some sort but I am uncertain. The source agency hasn't returned any
> of my calls so I'm wondering if anyone is familiar with this extension?
> I'd like to import the file into my database - when I use DTS and chose
> a text format, regardless of what delimiter I choose, the format is
> still really ugly. when I pull it up in a huge text editor, it is hard
> for me to tell what it is there.
> I saw in one of my searches that it could be a comma delimited (it's
> not) .. could be a unisys file? I know it's not much information to go
> on - but where should I start in trying to get this into my database
> without knowing the format? Any suggestions would be greatly
> appreciated.
> Thanks!
> Bethany
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!