Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rakshit46113
Starting Member
1 Post |
 Posted - 2008-06-12 : 06:53:29
|
| Hi,I have two tables where I maintain source vs destination column mapping and table mapping. I have one SP which creates other extract and load SPs using this mapping information, with the help of dynamic SQL. I call this SP as ETL generator. The greatest advantage is, even if in future some new source come into the picture, the SP stated above can generate ETL SPs for this new source using new column mapping. So the idea is we wanted to do only the column mapping potion and using the generator SP we wanted to create ETL SPS for new source automatically. The same is applicable if some change is required in existing mapping. We have already done this and implemented. Now we want to achieve the same functionality using SSIS package. Somebody told me that using XML dynamic SSIS package can be created. I can render the column mapping to XML and can then use the same to generate SSIS package dynamically. Would be great help if anyone can give some idea on this. Thanks in advance.RegardsRak. |
|
|
|
|
|
Metadata Driven dynamic SSIS package.