Error when transferring data from local database to hosted database

Hi,

I tried to tranfers some database tables from my local SQL Server 2000 database to a hosted database (SQL Server 2005) MSSQL Management Studio 2005. I did the same job successfully before also from my local MSSQL2000 to another hosted MSSQL2005 database. However, this time I encounter the following problem (in red below).

I opened a ticket for support from my service provider but they seemed to have no idea. Therefore, I must seek for help on this forum. Could anyone please give me some advice? Thank you very much in advance.

Regards,
Kenny

Messages
* ERROR : errorCode=-1073548784 description=Executing the query "CREATE TABLE [islandwidecatering.com.sg].[dbo].[Affiliates] (
[AffiliateId] int NOT NULL,
[VendorId] int,
[StartDate] datetime,
[EndDate] datetime,
[CPC] float NOT NULL,
[Clicks] int NOT NULL,
[CPA] float NOT NULL,
[Acquisitions] int NOT NULL
)
" failed with the following error: "Could not allocate space for object 'sys.syscolpars'.'clst' in database 'islandwidecatering.com.sg' 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.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
helpFile= helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC} (Microsoft.SqlServer.DtsTransferProvider)

It seems there is no available space for the new table. You can try to configure the databse to auto growth, or delete useless data to free space.

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.