error running ssis package

Hello.

I run a ssis package of transferring data between sql2005 databases.

I get this error:

Code Snippet

Error: 0xC002F325 at CopyTables2, Transfer SQL Server Objects Task: Execution failed with the following error:

"ERROR : errorCode=-1071636471 description=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 continue scan with NOLOCK due to data movement.".

helpFile=dtsmsg.rll helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}".

Task failed: CopyTables2

i run the package currently with right click on the package on the BIDS.

what is the reason for this error? how can I check it?

Thanks.

Check if it works y removing the WITH (NOLOCK) hint.

Virendra

|||

where or how can i remove it (remove the with nolock hint)?

|||

In the adapter where you have selected the tables as source and destination try setting the property Table Lock to true (check the check box - Table Lock).

Virendra

|||

thanks for your answer.

i'm sorry, i dont find it. i configured the transfer sql server object from the Bids.

i didnt see there Table Lock property.

where is it exactly?

Thanks.

|||

You are using the OLE DB Source and Destination adapter right? There when you select the table - fast load option you have the Table Lock check box. Check this.

Virendra

|||

Virendra Wadekar wrote:

You are using the OLE DB Source and Destination adapter right?

No, the OP is using the Transfer SQL Server Objects task. I don't see a way to set the table lock options on this task. You might have to use data flows to do this, or schedule the package to run at a time when data isn't being updated.