Error 17066

In the last week we are seeing several occurrences of the following error:
Error 602, Severity 21, State 30:
Could not find an entry for table or index with partitionID 189907171868672 in database 2.

This is always followed by a stack dump and this error:
SQL Server Assertion: File: <qxcntxt.cpp>, line = 1069 Failed Assertion = 'cref == 0'.

I have run checkdb on tempdb and no errors are reported. Additionally, we have dropped and recreated the sp indicated in the stack dump. The errors continue.

We are running 64 bit SQL 2005 with sp2.

HELP!!!!!!!!!!!!!!!!!!!!!!!!!!

Stack dump normally means a bug in sqlserver. It's best to contact PSS to get it resolved.

error 0xc0202055...while import data from csv file

I receiveed the error:

Error 0xc0202055: Data Flow Task: The column delimiter for column "Column x" was not found.

I would like to have the import continue., even the error occur. I have the error output to ignore, but doesn't seem to be working. Any suggestion on what to do next, or how to skip the row that create the problem.

thanks

We'll need a little more information - is the .csv file in a valid format? Does it have an inconsistent number of columns? If so, you should check out these posts - one for a workaround, the other for another workaround and some background info.

http://agilebi.com/cs/blogs/jwelch/archive/2007/05/07/handling-flat-files-with-varying-numbers-of-columns.aspx

http://blogs.conchango.com/jamiethomson/archive/2007/05/15/SSIS_3A00_--Flat-File-Connection-Manager-issues.aspx

Error - Installing SQL Server 2005 Client Tools

Hello

I am trying to install sql server 2005 client tools and I get the following error:

Error code 2356 : Could not locate cabinet in stream : sql.cab

How can I go about this

Thanks

Vaddi, how are you trying to install? Network share, media, or locally? Typically this error is a result of a corrupt package. Can you try to download again and retry? It should work for you then. Let me know if you hit any other errors.

Thanks,
Sam Lester (MSFT)

Error - Installing SQL Server 2005 Client Tools

Hello

I am trying to install sql server 2005 client tools and I get the following error:

Error code 2356 : Could not locate cabinet in stream : sql.cab

How can I go about this

Thanks

Vaddi, how are you trying to install? Network share, media, or locally? Typically this error is a result of a corrupt package. Can you try to download again and retry? It should work for you then. Let me know if you hit any other errors.

Thanks,
Sam Lester (MSFT)