源和目标的动态连接 [英] Dynamic connection for source and destination

问题描述

嗨专家，

我是SSIS的新手。我的要求是： - 我必须使用动态连接字符串从一个数据库获取数据并使用动态连接字符串将数据加载到数据库。意味着连接字符串是变化的怎么做到这一点？请建议我。紧急事情。



谢谢。

Hi experts,
I am new to SSIS. My requirement is :- I have to take data from one database with dynamic connection string and load data to a database with dynamic connection string. Means connection string is varying. How to achieve this? Kindly suggest me. Its something urgent.

Thanks.

推荐答案

继续创建与目前任何东西的连接。

然后在连接管理器窗口中选择您的连接。

单击属性窗口中的表达式，然后将ConnectionString设置为Provider = SQLOLEDB.1; Data Source =+ @ [User :: arg_srvr] +; Password =+ @ [User :: arg_pwd] +; User ID =+ @ [User :: arg_user] +; Initial Catalog =+ @ [User :: arg_db]



然后你需要传递值，这取决于你如何解雇你的包裹。

Go ahead and create the connections to whatever you have currently.
Then select your connection in the Connection Managers window.
Click Expressions in the Properties window and then set your ConnectionString to be something like "Provider=SQLOLEDB.1;Data Source=" + @[User::arg_srvr] + ";Password=" + @[User::arg_pwd] + ";User ID=" + @[User::arg_user] +";Initial Catalog=" + @[User::arg_db]

Then you''ll need to pass in the values depending on how you are firing off your package.

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