Could not continue scan with NOLOCK due to data movement

Question

I'm using SSIS 2008, SQL Server 2008 R2.

I'm trying to create a data flow task which takes data from an excel file, and locates it in a local database table.

I established the excel file connection, and created OLE DB Destination.

After I choose the local connection server, I'm trying to choose the target table for the data but it doesn't find me any table and what I see is:

 

The test connection to the local server is ok, I can't find a solution to this.

Can somebody help?

Thanks.

Answer 1

Could be a database corruption, your DBA nees to check if fix it.

If not the case, then see if any items on http://www.mssqlfix.com/2012/09/msg-601-could-not-continue-scan-with.html apply.

---

Arthur My Blog

Answer 2

It is a local database, so I don't have any DBA. I can't find any practical solution in the link you gave me...

Answer 3

What edition of SQL Server 2008 R2 it is and its patch level?

Still thinking it is a db corruption, can you run DBCC CHECKDB?

---

Arthur My Blog

Answer 4

Hi,

I got: 

CHECKDB found 0 allocation errors and 0 consistency errors in database 'PhilipsMaterials'.

SQL Server properties:

Answer 5

That's the SSMS, not SQL Server.

In SSMS type in

SELECT @@VERSION;

Hit F5 and post what you get here

---

Arthur My Blog

Answer 6

Thanks,

I got:

Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (X64)   Jul  9 2008 14:17:44   Copyright (c) 1988-2008 Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) 

Answer 7

Hi Onca,

According to the error message, it seems that the database is corrupted, please refer to Rock Wang's reply: http://social.technet.microsoft.com/forums/en-CA/sharepointadminprevious/thread/dfedb92c-1c25-468c-9880-bce0d927b060

Thanks,
Eileen

---

Eileen Zhao
TechNet Community Support