ssis动态连接字符串变量

debugcn 发表于 Dev

用户3494471

我正在由某人创建集合SSIS软件包。示例如下所示在此处输入图片说明

他们在每个包中创建了Variables.In我的项目文件夹中，我可以找到Democonnectionstring

在此处输入图片说明

在Democonnectionstring内部在此处输入图片说明

我的问题是为什么他们要使用Variables和DemoConnectionString以及是否要在应该更改的地方更改服务器名和密码。任何人都向我详细解释。

戈文德

If you want to run your ssis package in BIDS(i.e in your development) you can change variable values in variable window according to your need then run the package. so now you can change your variables in variable window. But how you will change your variable if you have only executable dtsx package but not actual solution.

Here only configuration files comes into picture, where you can change all the dynamic variables without editing your packages. The demo password and password is something they might have created for test purpose. Try to remove one or other password and run the package, if it is working fine then remove unnecessary variables. If the variables prepend USER string then that is user defined variable. Right click your connection and go to properties window and check expression option to see any user variables assigned.

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。

编辑于2021-06-9

我来说两句

0条评论

登录后参与评论

来自分类Dev

Related 相关文章

文章