July 29, 2015 at 1:12 am
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
July 29, 2015 at 4:36 am
I guess using a foreach loop will do.
1>Fetch conn string, table names from master_table.
2>Foreach
[
Your DFT's here.
]
____________________________________________________________
APJuly 29, 2015 at 4:53 am
Ya that's correct for each loop wil work,
But my question is that within US zone I have 2 different source
out of 3 DFT 2 DFT have same source and 3rd DFT have different source.
how to handle this scenario now
July 29, 2015 at 5:10 am
vipin_jha123 (7/29/2015)
Ya that's correct for each loop wil work,But my question is that within US zone I have 2 different source
out of 3 DFT 2 DFT have same source and 3rd DFT have different source.
how to handle this scenario now
Please explain why the for each loop is not satisfactory in this case. Assume that we know nothing about your zones and sources (because we don't).
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
July 30, 2015 at 5:35 am
Hi Becouse As I explained earlier I am having 2 source connection for US .
Out of 3 DFT 2 DFT have sourceA and Last DFT have difrent source.
For each loop will take same connection for all the DFT in that case 3rd DFT will fail
regards,
Vipin Jha
July 30, 2015 at 5:53 am
vipin_jha123 (7/30/2015)
Hi Becouse As I explained earlier I am having 2 source connection for US .Out of 3 DFT 2 DFT have sourceA and Last DFT have difrent source.
For each loop will take same connection for all the DFT in that case 3rd DFT will fail
regards,
Vipin Jha
Then nest a foreach loop for connections inside a foreach loop for zones.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
July 30, 2015 at 5:55 am
Do you have similar example of ssis packages
August 4, 2015 at 3:03 am
vipin_jha123 (7/30/2015)
Hi Becouse As I explained earlier I am having 2 source connection for US .Out of 3 DFT 2 DFT have sourceA and Last DFT have difrent source.
For each loop will take same connection for all the DFT in that case 3rd DFT will fail
regards,
Vipin Jha
Take two different connection managers then.
____________________________________________________________
APViewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply