insert bulk [schemaName].[TableName]
(
[ItemId] int,
[MasterId] int,
[ItemCategoryId] int,
[ItemCategoryValue] varchar(1000) collate Chinese_PRC_CI_AS,
[ItemDateTime] datetime,
[ItemEndDateTime] datetime,
[TravelFrom] varchar(1000) collate Chinese_PRC_CI_AS,
[TravelTo] varchar(1000) collate Chinese_PRC_CI_AS,
[Comments] varchar(2000) collate Chinese_PRC_CI_AS,
[Deleted] bit,
[CreatedUserId] varchar(11) collate Chinese_PRC_CI_AS,
[CreatedAt] datetime,
[LastModifiedUserId] varchar(11) collate Chinese_PRC_CI_AS,
[LastModifiedAt] datetime,
[PunchedAt] datetime,
[ItemStateId] int
)with
(
TABLOCK,CHECK_CONSTRAINTS
)
马来项目,使用SSIS做数据的迁移。
准备先导到本地,所以在本地建了一个新库。测试时报Error code: 0x80004005的错误。
错误的描述为:
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "OLE DB provider 'STREAM' for linked server '(null)'