SQL SERVER SSIS常见错误

Hannah

于 2023-01-29 14:00:50 发布

阅读量1.4k

点赞数

文章标签：数据库 Powered by 金山文档

本文链接：https://blog.csdn.net/nan2008zzu/article/details/128788245

版权

EXCEL相关文件处理

Message

Executed as user: DCCN01-018-...\nnit..admin..... Microsoft (R) SQL Server Execute Package Utility Version 15.0.4261.1 for 32-bit Copyright (C) 2019 Microsoft. All rights reserved. Started: 5:49:22 AM Error: 2023-01-29 05:49:24.19 Code: 0xC002F304 Source: File 01 Copy File System Task Description: An error occurred with the following error message: "The file 'D:\COBISFlatFile\COPAM\SAP\SCSpeaker\01_COPAMNewSpeaker_20230129.xls' already exists.". End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 5:49:22 AM Finished: 5:49:24 AM Elapsed: 1.516 seconds. The package execution failed. The step failed.

解决：在属性下找到设置 execution options -->Use 32-bit runtime 勾选此选项，重新运行，解决。