July 15, 2008 at 1:01 am
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
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply