I have requirement like,
-- We are maintaining queries in a table
-- By using single ssis Package we need to pull the data from the queries and place the rest data in destination.
I have implemented the package in the following way,
-- By using foreachloop, I am getting query to the variable, and using the same in Datasource by dataaccessmode as "SqlcommandFromvariable".
-- For the data flow task I have set the delay validation property to "True".
The problem I have faced is, we have Queries with different Column names.
For the first query I have the column name "Empid" with datatype as int. In my second query there the column name is like "optionId" datatype is uniqueIdentifier. I am getting error message as shown below
[ODS - GetDatfromProdServer ] Error: Column "optionId" cannot be found at the datasource.
The external column name list is same as while creating the package, In my case it showing as "Empid". It is not changing based on the source query.
please help me on this.