动态SIS包在运行时更改源连接 [英] Dynamic SIS package changing source connection at run time
问题描述
大家好，
我介意创建一个动态的SSSIS包，它将运行多个具有不同源连接的区域。
我的源代码是在Oracle中。
我有3个DFT和3个不同的源表。
我想动态创建一个包含DFT的包，这样我的单个包可以通过动态源连接更改来运行整个区域。
我创建了一个Master表，用于存储区域源连接字符串和区域名称。
所以如果将来任何新区域只有新区域细节需要在主表格中添加而无需打开包装。
请建议我更好的方法来实现上述方案。
在附件中你可以看到ETL包装设计
谢谢和问候，
Vipin Jha
Hi All,
I am in between of creating a dynamic SSSIS package which will run for multiple zones having different source connection.
My source is in Oracle.
I am having 3 DFT with the 3 different source tables.
I want to create a package with above DFT dynamically so that my single package can run for the entire zone with dynamically source connection change.
I have created a Master table which stores the zone source connection string and zone name.
so if in future any new zones come so only newly zone details need to be add in master table without opening the package.
Please suggest me the better approach to achieve the above scenario.
In attached file you can see the ETL package design
Thanks & Regards,
Vipin Jha
推荐答案
SSIS中的动态支持从未真正给我留下深刻印象，但是你需要d考虑它面向的用户类型，非开发者。
看一下这篇文章，它应该可以帮助你开始这个：
SSIS动态连接 [ ^ ]
过去，我也编写过类似操作的C＃脚本，但我对这条路线也没有留下太深刻的印象。以下是YouTube视频演示：
SSIS中C＃脚本简介 [ ^ ]
如果您使用的是SQL Server 2012及更高版本，我建议您查看一下：
SSIS 2012项目：部署配置和监控 [ ^ ]
如果您的包装相同或通用，您可能可以制作环境。
The dynamic support in SSIS never really impressed me, but you need to consider the type of user it was geared towards, non-developers.
Take a look at this post, it should help you get started with this:
SSIS Dynamic Connections[^]
In the past, I've also wrote C# scripts that do similar manipulation, but I wasn't really impressed with that route either. Here is a YouTube video that demos it:
Introduction to C# Scripting in SSIS[^]
If you are using SQL Server 2012 and higher, I would suggest taking a look at this:
SSIS 2012 Projects: Deployment Configurations and Monitoring[^]
If your packages are identical or generic enough, you might be able to make of environments.
这篇关于动态SIS包在运行时更改源连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
