Hi,
I am new to the SSIS. I am trying to load multiple tables from my staging database to multiple tables in the data warehouse. My staging database is nothing but a database with all the tables from all my source databases copied to it. I found that each data flow task only allows to connect one source table to one destination table.
I am having 100 of SSIS package of 100 Tables.
I want to make single SSIS package to laod all the 100 tables usning single DFT.
I have a filmaster table which containing the list of source table and destination table name, and input will be the filename , on the basis of filename my DFT will take the source and derstination table and run the package accordingly.
Is this approach is correct, or is it possible, is dynamically column mapping is possible.
Please suggets some ideas on above concern
Regards,
Vipin Jha
I am new to the SSIS. I am trying to load multiple tables from my staging database to multiple tables in the data warehouse. My staging database is nothing but a database with all the tables from all my source databases copied to it. I found that each data flow task only allows to connect one source table to one destination table.
I am having 100 of SSIS package of 100 Tables.
I want to make single SSIS package to laod all the 100 tables usning single DFT.
I have a filmaster table which containing the list of source table and destination table name, and input will be the filename , on the basis of filename my DFT will take the source and derstination table and run the package accordingly.
Is this approach is correct, or is it possible, is dynamically column mapping is possible.
Please suggets some ideas on above concern
Regards,
Vipin Jha
Manish Kumar ChoudharyPosted Dec 11, 2014, 4:02 AM
Hi vipin jha,
Go through following links it may help you.
https://www.simple-talk.com/sql/ssis/ssis-basics-using-the-merge-join-transformation/
http://stackoverflow.com/questions/16009503/ssis-multiple-table-loads
vipin jhaPosted Dec 11, 2014, 11:43 PM
can u check that package ?
regards,
Vipin jha
vipin jhaPosted Dec 11, 2014, 11:41 PM
I visited the link given by you ,
please suggest some more link
regards,
Vipin jha
Manish Kumar ChoudharyPosted Dec 11, 2014, 11:24 PM
Go through following links it may help u
https://gallery.technet.microsoft.com/scriptcenter/Dynamic-SSIS-Generation-to-ccbab86b
http://www.codeproject.com/Articles/69325/Using-Conditional-Split-data-Transfer-in-SSIS
vipin jhaPosted Dec 11, 2014, 11:09 PM
Above given link is not usefull for me at all.
I want to load all table using single DFT
I am having 100 source table and 100 destination table
I have 1 master table which contains the list of all the table.
In DFT , Tbales should changed on fly dynamically
Regards,
Vipin jha