SSIS 部署包无法将驱动器标签映射到网络共享文件夹 [英] SSIS deployed package fails to map drive tag to network shared folder

问题描述

以朋友的身份修改这篇文章帮助我弄清楚了.

Modifying this post as a friend has helped me figure it out.

罪魁祸首是 SQL 无法将驱动器标签映射到网络共享文件夹，因此部署的 SSIS 包无法写入.执行报告显示全部绿色和成功，所以作为初学者的我很困惑.另请参阅下面的评论.

The culprit was that SQL was not able to map drive tag to network shared folder, so the deployed SSIS package was not able to write. The execution report showed all green and success, so I was confused as a beginner. See also the comments below.

备份以下原始帖子:

SSIS 包文本文件写入工作在 Visual Studio 中而不是部署在 sql server 上

SSIS package text file write works in visual studio not when deployed on sql server

我已经将问题缩小到脚本任务(C#)中的文本文件写入操作，实验只是将当前时间戳写入文本文件.

I have narrowed down the issue to the text file writing action in script task (C#), the experiment simply writes the current time stamp into a text file.

它可以在 Visual Studio 2015 中使用 (F5) 和不使用 (Cntl+F5) 调试器.项目处于包部署模式.部署到SQL Server 2016的数据库服务器，用管理员登录手动触发execute后，虽然执行报告显示全部成功，但写操作永远不会发生，Windows系统日志也没有给我任何线索.

It works in Visual Studio 2015, both with (F5) and without (Cntl+F5) Debugger. The project is in package deployment mode. When deployed to a database server of SQL Server 2016 and manually trigger execute with Administrator login, the writing action never happens although execution report shows all success, and Windows system log shows no clue to me either.

我是 SSIS 的初学者，非常感谢提示和技巧.

I am a beginner on SSIS and hints and tips will be highly appreciated.

推荐答案

是的，SSIS 不喜欢将共享文件夹映射到盘符驱动器.谢谢@Nick.McDermaid.

Yes, SSIS doesn't like mapping shared folder to a letter drive. Thanks @Nick.McDermaid .

切勿使用映射驱动器.改用 UNC，即 \server\share\folder –Nick.McDermaid 18 年 11 月 8 日 23:40

Never use mapped drives. Use UNC instead i.e. \server\share\folder – Nick.McDermaid Nov 8 '18 at 23:40

这篇关于SSIS 部署包无法将驱动器标签映射到网络共享文件夹的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！