I have a dynamic DFT problem and will appreciate your help in resolving that. We are storing source queries / stored procedure and mapping between source and destination column in a database and trying to create DFT which will execute the source queries and then map columns based on the mapping stored in the database. The number of source columns can vary in different sources. I was able to execute different queries when the source columns name were not changing but not able to find solution when number of source columns or their name are changing. Can you suggest any solution for this problem
Data Flow task is not designed to handle varying meta data. So this cannot be used. May be writing a .NET code would help in your case or if you can write dynamic SPs to do the ETL for you.
Hi,
ReplyDeleteI have a dynamic DFT problem and will appreciate your help in resolving that. We are storing source queries / stored procedure and mapping between source and destination column in a database and trying to create DFT which will execute the source queries and then map columns based on the mapping stored in the database. The number of source columns can vary in different sources. I was able to execute different queries when the source columns name were not changing but not able to find solution when number of source columns or their name are changing.
Can you suggest any solution for this problem
Thanks
SG
Data Flow task is not designed to handle varying meta data. So this cannot be used. May be writing a .NET code would help in your case or if you can write dynamic SPs to do the ETL for you.
ReplyDelete