SQL Server Bulk load issue

info_ds · Post by **info_ds** » Tue Jan 29, 2008 12:05 pm

Hi All,

I tried loading data from a flat file to SQL server using SQLBLK7 Bulk loader stage.I got the following error message.

Internal error: Failed to allocate row buffer memory.
Failed to prepare fast load session.

Is this something to do with DataStage or Sql Server DB?

I searched the forum,could not find about the row buffer memory issue.
Any suggestions much appreciated.

Thanks

ray.wurlod · Post by **ray.wurlod** » Tue Jan 29, 2008 9:11 pm

Another possibility is that your row size is larger than that declared - or, perhaps, permissible - in the bulk loader.

info_ds · Post by **info_ds** » Wed Jan 30, 2008 5:12 am

ray.wurlod wrote:Another possibility is that your row size is larger than that declared - or, perhaps, permissible - in the bulk loader. ...

Ray,Thanks for the input.

The Bulk load works absolutely fine for one table wherein i'm inserting 1.7 millions records.Totally there are around 6 attributes in the table.

But when I tried loading the other table using Bulk load with just 700,000 records,it failed with an error message 'Failed to allocate row buffer memory'.This table has around 20 attributes.

Will the data density be an issue?

Even I tried using ODBC stage,but in vain.It failed with an error message 'Abnormal Termination'.

Any suggestions?

ray.wurlod · Post by **ray.wurlod** » Wed Jan 30, 2008 4:09 pm

My previous post talked about row size, not about total volume.