将参数传递给SSIS包 [英] Passing paramters to SSIS package

问题描述

嗨



解释下面的情景。



我在SSIS包中有一个选择查询。



Ex：

Hi

Explaining the below Scenario.

I have a select query in the SSIS Package.

Ex:

Select distinct from Entity_id_dim_table where ID='?'

我希望从.txt文件（从本地驱动器）中获取ID，并且需要将id值映射到where子句（'？'）。



查询存在于SSIS包的数据流任务中。



根据ID值，它应该检索价值。



如何使用SSIS包？参数概念？如何解决这个问题？



请尽早通知我。



提前致谢。

Sandeep



我尝试过：



你好



解释下面的场景。



我在SSIS包中有一个选择查询。



Ex：



选择与Entity_id_dim_table不同，其中ID ='？'



我希望从.txt文件（从本地驱动器）中获取ID，并且需要将id值映射到where子句（'？'）。



查询存在于SSIS包的数据流任务中。



根据ID值，它应检索该值。 />


如何使用SSIS包？参数概念？如何解决这个问题？



请尽早通知我。



提前致谢。

Sandeep

I want the ID to be picked up from the .txt file(from local drive) and id value need to mapped to the where clause ('?')place.

Query is present in the data flow task of the SSIS Package.

Depending on the ID value , it should retrieve the value.

How to achieve using the SSIS package ? parameter concept ? how to resolve the issue?

Please let me know as early as possible.

Thanks in advance.
Sandeep

What I have tried:

Hi

Explaining the below Scenario.

I have a select query in the SSIS Package.

Ex:

Select distinct from Entity_id_dim_table where ID='?'

I want the ID to be picked up from the .txt file(from local drive) and id value need to mapped to the where clause ('?')place.

Query is present in the data flow task of the SSIS Package.

Depending on the ID value , it should retrieve the value.

How to achieve using the SSIS package ? parameter concept ? how to resolve the issue?

Please let me know as early as possible.

Thanks in advance.
Sandeep

推荐答案

这不是一个解决问题的案例，更能指出你的研究正确的方向。



这些将是很好的起点：



在运行时从包外传递值到SSIS包 - SQLServerCentral [ ^ ]



sql server 2008 - 使用不同的参数执行相同的SSIS包在不同时间发生 - Stack Overflow [ ^ ]



将动态参数值传递给SQL Server Integration Services [ ^ ]

This is not a case of resolving an issue, more pointing you in the right direction for your research.

These will be good starting points:

Passing Values into an SSIS Package at Runtime from Outside the Package - SQLServerCentral[^]

sql server 2008 - Executing the same SSIS Package with different parameters at different time - Stack Overflow[^]

Pass dynamic parameter values to SQL Server Integration Services[^]

这篇关于将参数传递给SSIS包的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！