SQL Server 2005 import error

  • 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