Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server 2005 import error Expand / Collapse
Author
Message
Posted Tuesday, July 15, 2008 1:01 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, August 20, 2008 1:31 AM
Points: 11, Visits: 31
Hi,

I am getting the following error while importing the data from SQL server 2000.

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: "Unspecified error".
helpFile=dtsmsg.rll helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC} (Microsoft.SqlServer.DtsTransferProvider)

Please help me urgently as it is very very important.

Following is the report I am getting:

Operation stopped...

- Create a TransferProvider. (Success)

- Create a temporary file for destructive SQL. (Success)

- Create a temporary file for constructive SQL. (Success)

- Create a temporary XML file for table metadata. (Success)

- Configure the TransferProvider with files and Source/Destination connection info. (Success)

- Execute the transfer with the TransferProvider. (Error)
Messages
* 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: "Unspecified error".
helpFile=dtsmsg.rll helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC} (Microsoft.SqlServer.DtsTransferProvider)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476


- Execute the destructive SQL. (drop tables) (Success)

- Execute the constructive SQL. (create tables) (Success)

- Create a temporary table transfer package for [dbo].[dtproperties] (Success)

- Execute transfer package for [dbo].[dtproperties] (Success)

- Copying to [dbo].[dtproperties] (Success)
* 7 rows transferred

- Create a temporary table transfer package for [dbo].[TBL_BUNDLEMAP] (Success)

- Execute transfer package for [dbo].[TBL_BUNDLEMAP] (Success)

- Copying to [dbo].[TBL_BUNDLEMAP] (Success)
* 27 rows transferred

- Create a temporary table transfer package for [dbo].[TBL_ERRORLOG] (Success)

- Execute transfer package for [dbo].[TBL_ERRORLOG] (Success)

- Copying to [dbo].[TBL_ERRORLOG] (Success)
* 7914 rows transferred

- Create a temporary table transfer package for [dbo].[TBLADMIN_MODULELOCK_TRN] (Success)

- Execute transfer package for [dbo].[TBLADMIN_MODULELOCK_TRN] (Success)

- Copying to [dbo].[TBLADMIN_MODULELOCK_TRN] (Success)
* 0 rows transferred

- Create a temporary table transfer package for [dbo].[TBLAUDITLOG_TRN] (Success)

- Execute transfer package for [dbo].[TBLAUDITLOG_TRN] (Success)

- Copying to [dbo].[TBLAUDITLOG_TRN] (Success)
* 231023 rows transferred

- Create a temporary table transfer package for [dbo].[TBLCHANGE_TRN] (Success)

- Execute transfer package for [dbo].[TBLCHANGE_TRN] (Success)

- Copying to [dbo].[TBLCHANGE_TRN] (Success)
* 48 rows transferred

- Create a temporary table transfer package for [dbo].[TBLCOMP_BT_BUNDLE_MAP] (Success)

- Execute transfer package for [dbo].[TBLCOMP_BT_BUNDLE_MAP] (Success)

- Copying to [dbo].[TBLCOMP_BT_BUNDLE_MAP] (Success)
* 9 rows transferred

- Create a temporary table transfer package for [dbo].[TBLCOMP_KF_WM_TRN] (Success)

- Execute transfer package for [dbo].[TBLCOMP_KF_WM_TRN] (Success)

- Copying to [dbo].[TBLCOMP_KF_WM_TRN] (Success)
* 116 rows transferred

- Create a temporary table transfer package for [dbo].[TBLCOMPETITOR_MST] (Success)

- Execute transfer package for [dbo].[TBLCOMPETITOR_MST] (Success)

- Copying to [dbo].[TBLCOMPETITOR_MST] (Success)
* 36 rows transferred

- Create a temporary table transfer package for [dbo].[TBLDB_LOG_TRN] (Success)

- Execute transfer package for [dbo].[TBLDB_LOG_TRN] (Success)

- Copying to [dbo].[TBLDB_LOG_TRN] (Success)
* 12715 rows transferred

- Create a temporary table transfer package for [dbo].[TBLDESTINATION_MST] (Success)

- Execute transfer package for [dbo].[TBLDESTINATION_MST] (Success)

- Copying to [dbo].[TBLDESTINATION_MST] (Success)
* 250 rows transferred

- Create a temporary table transfer package for [dbo].[TBLDISTMAIL_TRN] (Success)

- Execute transfer package for [dbo].[TBLDISTMAIL_TRN] (Success)

- Copying to [dbo].[TBLDISTMAIL_TRN] (Success)
* 15 rows transferred

- Create a temporary table transfer package for [dbo].[TBLFAVORITE_TRN] (Success)

- Execute transfer package for [dbo].[TBLFAVORITE_TRN] (Success)

- Copying to [dbo].[TBLFAVORITE_TRN] (Success)
* 1810 rows transferred

- Create a temporary table transfer package for [dbo].[TBLFEEDBACK_TRN] (Success)

- Execute transfer package for [dbo].[TBLFEEDBACK_TRN] (Success)

- Copying to [dbo].[TBLFEEDBACK_TRN] (Success)
* 133 rows transferred

- Create a temporary table transfer package for [dbo].[TBLGROUP_MST] (Success)

- Execute transfer package for [dbo].[TBLGROUP_MST] (Success)

- Copying to [dbo].[TBLGROUP_MST] (Success)
* 66 rows transferred

- Create a temporary table transfer package for [dbo].[TBLHOME_LINKS] (Success)

- Execute transfer package for [dbo].[TBLHOME_LINKS] (Success)

- Copying to [dbo].[TBLHOME_LINKS] (Success)
* 77 rows transferred

- Create a temporary table transfer package for [dbo].[TBLITEM_MST] (Success)

- Execute transfer package for [dbo].[TBLITEM_MST] (Success)

- Copying to [dbo].[TBLITEM_MST] (Success)
* 621 rows transferred

- Create a temporary table transfer package for [dbo].[TBLITEM_PART_TYPE_MST] (Success)

- Execute transfer package for [dbo].[TBLITEM_PART_TYPE_MST] (Success)

- Copying to [dbo].[TBLITEM_PART_TYPE_MST] (Success)
* 15 rows transferred

- Create a temporary table transfer package for [dbo].[TBLLOB_MST] (Success)

- Execute transfer package for [dbo].[TBLLOB_MST] (Success)

- Copying to [dbo].[TBLLOB_MST] (Success)
* 6 rows transferred

- Create a temporary table transfer package for [dbo].[TBLLOCATIONS_MST] (Success)

- Execute transfer package for [dbo].[TBLLOCATIONS_MST] (Success)

- Copying to [dbo].[TBLLOCATIONS_MST] (Success)
* 14 rows transferred

- Create a temporary table transfer package for [dbo].[TBLMENU_MST] (Success)

- Execute transfer package for [dbo].[TBLMENU_MST] (Success)

- Copying to [dbo].[TBLMENU_MST] (Success)
* 75 rows transferred

- Create a temporary table transfer package for [dbo].[TBLOUC_MST] (Stopped)

- Execute transfer package for [dbo].[TBLOUC_MST] (Stopped)

- Copying to [dbo].[TBLOUC_MST] (Stopped)

- Create a temporary table transfer package for [dbo].[TBLPROD_GROUP_ITEM_TRN] (Stopped)

- Execute transfer package for [dbo].[TBLPROD_GROUP_ITEM_TRN] (Stopped)

- Copying to [dbo].[TBLPROD_GROUP_ITEM_TRN] (Stopped)

- Create a temporary table transfer package for [dbo].[TBLPRODUCT_CATEGORY_MST] (Stopped)

- Execute transfer package for [dbo].[TBLPRODUCT_CATEGORY_MST] (Stopped)

- Copying to [dbo].[TBLPRODUCT_CATEGORY_MST] (Stopped)

- Create a temporary table transfer package for [dbo].[TBLPRODUCT_ITEM_LINKS] (Stopped)

- Execute transfer package for [dbo].[TBLPRODUCT_ITEM_LINKS] (Stopped)

- Copying to [dbo].[TBLPRODUCT_ITEM_LINKS] (Stopped)

- Create a temporary table transfer package for [dbo].[TBLPRODUCT_ITEM_LINKS_BB] (Stopped)

- Execute transfer package for [dbo].[TBLPRODUCT_ITEM_LINKS_BB] (Stopped)

- Copying to [dbo].[TBLPRODUCT_ITEM_LINKS_BB] (Stopped)

- Create a temporary table transfer package for [dbo].[TBLPRODUCT_ITEM_PPM_LINKS] (Stopped)

- Execute transfer package for [dbo].[TBLPRODUCT_ITEM_PPM_LINKS] (Stopped)

- Copying to [dbo].[TBLPRODUCT_ITEM_PPM_LINKS] (Stopped)

- Create a temporary table transfer package for [dbo].[TBLPRODUCT_MST] (Stopped)

- Execute transfer package for [dbo].[TBLPRODUCT_MST] (Stopped)

- Copying to [dbo].[TBLPRODUCT_MST] (Stopped)

- Create a temporary table transfer package for [dbo].[TBLPROFILE_MST] (Stopped)

- Execute transfer package for [dbo].[TBLPROFILE_MST] (Stopped)

- Copying to [dbo].[TBLPROFILE_MST] (Stopped)

- Create a temporary table transfer package for [dbo].[TBLPROXY_TABLE] (Stopped)

- Execute transfer package for [dbo].[TBLPROXY_TABLE] (Stopped)

- Copying to [dbo].[TBLPROXY_TABLE] (Stopped)

- Create a temporary table transfer package for [dbo].[TBLREGIONS_MST] (Stopped)

- Execute transfer package for [dbo].[TBLREGIONS_MST] (Stopped)

- Copying to [dbo].[TBLREGIONS_MST] (Stopped)

- Create a temporary table transfer package for [dbo].[TblSequence] (Stopped)

- Execute transfer package for [dbo].[TblSequence] (Stopped)

- Copying to [dbo].[TblSequence] (Stopped)

- Create a temporary table transfer package for [dbo].[TBLSERVICEINFO_TRN] (Stopped)

- Execute transfer package for [dbo].[TBLSERVICEINFO_TRN] (Stopped)

- Copying to [dbo].[TBLSERVICEINFO_TRN] (Stopped)

- Create a temporary table transfer package for [dbo].[TBLSESSEION_USER_MST] (Stopped)

- Execute transfer package for [dbo].[TBLSESSEION_USER_MST] (Stopped)

- Copying to [dbo].[TBLSESSEION_USER_MST] (Stopped)

- Create a temporary table transfer package for [dbo].[TBLSESSION_LOG_TRN] (Stopped)

- Execute transfer package for [dbo].[TBLSESSION_LOG_TRN] (Stopped)

- Copying to [dbo].[TBLSESSION_LOG_TRN] (Stopped)

- Create a temporary table transfer package for [dbo].[TBLUSER_HOMELINK] (Stopped)

- Execute transfer package for [dbo].[TBLUSER_HOMELINK] (Stopped)

- Copying to [dbo].[TBLUSER_HOMELINK] (Stopped)

- Create a temporary table transfer package for [dbo].[TBLUSER_MENU] (Stopped)

- Execute transfer package for [dbo].[TBLUSER_MENU] (Stopped)

- Copying to [dbo].[TBLUSER_MENU] (Stopped)

- Create a temporary table transfer package for [dbo].[TBLUSER_MST] (Stopped)

- Execute transfer package for [dbo].[TBLUSER_MST] (Stopped)

- Copying to [dbo].[TBLUSER_MST] (Stopped)

- Create a temporary table transfer package for [dbo].[TBLVAS_MST] (Stopped)

- Execute transfer package for [dbo].[TBLVAS_MST] (Stopped)

- Copying to [dbo].[TBLVAS_MST] (Stopped)

- Create a temporary table transfer package for [dbo].[TBLVERSION_MST] (Stopped)

- Execute transfer package for [dbo].[TBLVERSION_MST] (Stopped)

- Copying to [dbo].[TBLVERSION_MST] (Stopped)

- Create a temporary table transfer package for [dbo].[addProd_item_value] (Stopped)

- Execute transfer package for [dbo].[addProd_item_value] (Stopped)

- Copying to [dbo].[addProd_item_value] (Stopped)




Thanks & Regards,
SS
Post #534082
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse