SSIS 项目连接 [英] SSIS Project Connections

问题描述

使用 Visual Studio 构建我的 SSIS 包.项目连接 - 它们看起来是个好主意，所以我会这样做而不是重复我的代码......

Using Visual Studio to build my SSIS packages. Project connections - they seem like a good idea so I'll do that instead of repeating my code....

当您尝试在 Visual Studio 之外单独运行包时出现问题，例如 dtexec，它们没有任何关联，因此它们会失败.

Problem when you try to run the packages individually outside Visual Studio, say dtexec, they don't have any connection associated with them so they fail.

我真的必须为所有 20 个包复制包连接吗?没有办法共享连接吗?

Do I really have to duplicate package connections for all 20 packages? Is there not a way to share a connection?

我希望能够单独/分组运行每个包，因为它们会有不同的时间表.

I want to be able to run each package separately/in groups as they will have a differing schedules.

我是一名开发人员，所以 Visual Studio 是我的默认转到 - SQL Server 会为此提供更好的房子吗?

I'm a developer so Visual Studio is my default goto - would SQL Server provide a better house for this?

谢谢

推荐答案

对于非基于项目的连接，当你运行包时，它会采用类似的形式

For non-project based connections, when you run the package, it'd take a form like

dtexec /file MyPackage.dtsx 

但是，对于基于项目的连接，您需要将该项目包含在 dtexec 调用.否则，您最终会丢失连接错误

However, for project based connections, you need to include the project in the dtexec call. Otherwise, you'll end up with missing connection errors

dtexec /package MyPackage.dtsx /project MyProject.ispac

注意:当前文档不准确，因为它指定了/file MyPackage.dtsx/project MyProject.ispac/File 参数对于项目部署模型解决方案无效

Note: the current documentation is inaccurate as it specifies /file MyPackage.dtsx /project MyProject.ispac The /File parameter is invalid for Project deployment model solutions

这篇关于SSIS 项目连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！