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
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