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 source error : so much rows

Hello,

I have a problem with my SSIS. I have a data flow with a file source in csv, but itself has 140 000 rows, so when I execute the date flow, I have a error who say that the data exceed the temp of I/O (sorry for the translate, but I have the message in french).
I test to pass the DefaultBufferMaxRow to 140000 but I have always the problem.

If we can help me, thank you.
You might try setting the BufferTempStoragePath property on the data flow to point to a drive with plenty of free space. If you search on the forum for that property, you'll find more information.|||Ok, I go to search it.

Thank you for your answer.

File source error : so much rows

Hello,

I have a problem with my SSIS. I have a data flow with a file source in csv, but itself has 140 000 rows, so when I execute the date flow, I have a error who say that the data exceed the temp of I/O (sorry for the translate, but I have the message in french).
I test to pass the DefaultBufferMaxRow to 140000 but I have always the problem.

If we can help me, thank you.
You might try setting the BufferTempStoragePath property on the data flow to point to a drive with plenty of free space. If you search on the forum for that property, you'll find more information.|||Ok, I go to search it.

Thank you for your answer.