基于变量的 SSIS 连接字符串 [英] SSIS connection string based on a variable

问题描述

这是我的问题的后续:基于参数的SSIS连接参数/变量

我现在可以看到如何从其他变量构造一个变量，但似乎不可能使用该变量作为 Connection 的 ConnectionString.这似乎只允许变量.

I now can see how to construct a variable from other variables, but it does not appear possible to then use that variable as the ConnectionString for the Connection. That appears to only allow variables.

如何将新连接的变量用作 ConnectionString?

How can I use my newly concatenated variable as the ConnectionString?

推荐答案

好的，我现在可以回答我自己的问题了.这与您想使用参数设置 ConnectionString 的位置不同.

Ok, I can answer my own question now. It is a different location than if you want to use a parameter to set the ConnectionString.

单击连接管理器中的连接，然后在属性窗口中展开表达式.在那里您可以单击 ... 将其设置为变量.

Click on the Connection in Connect Manager and in the Properties window, expand Expressions. There you can click the ... to set it to a variable.

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