quote:

---

Originally posted by LearningSQLKid

Thanks gbritton

Here is my problem and may be you can suggest some good points

I have a database called MetaDataDB. This database has a table called ETLLoadTables. The structure is below

TableId , TableName, Query
1 Customers Select CustomerID,CustomerName From Customers
2 Sale Select SaleID,CustomerID From Sale


Now I want to loop through this table get the Query In variable , pass this variable to source in dataflow and refresh the mappings and load it to destination .. is it possible to achieve in ssis 2008,2012 ?

I can use it EXECUTE SQL task but how can i make data flow to work in dynamic fashion. any idea


Thank you so much



Select Knowledge from LearningProcess

---

quote:

---

Originally posted by gbritton

quote:

---

Originally posted by LearningSQLKid

Thanks gbritton

Here is my problem and may be you can suggest some good points

I have a database called MetaDataDB. This database has a table called ETLLoadTables. The structure is below

TableId , TableName, Query
1 Customers Select CustomerID,CustomerName From Customers
2 Sale Select SaleID,CustomerID From Sale


Now I want to loop through this table get the Query In variable , pass this variable to source in dataflow and refresh the mappings and load it to destination .. is it possible to achieve in ssis 2008,2012 ?

I can use it EXECUTE SQL task but how can i make data flow to work in dynamic fashion. any idea


Thank you so much



Select Knowledge from LearningProcess

---

Things will work up until the "refresh the mappings" part. I know of no way to dynamically tell SSIS to do that. Think about it for a minute. When you build a package in the SSIS designer, it in turn builds an XML file (the .dtsx -- x is for XML) that eventually gets run. At execution time, the SSIS engine validates the dtsx file. I think that you are basically asking the engine to modify the dtsx on the fly. I don't believe that it can do that.

---