Dynamic Mapping For Source/Destination

Hello,

What I'm trying to accomplish is to have a variable names "SourceTable" and "DestinationTable". So for each SourceTable, the DestinationTable will have the same columns. All I need is to auto-map these columns between source and destination via code?

Is this possible?

Thanks,

awiora

You can do it, but not in the same package. Packages can't modify themselves while they are running. You can, however, use a package (with some code in it) to generate and call another package. Take a look at this post to see an example.

http://blogs.conchango.com/jamiethomson/archive/2007/03/28/SSIS_3A00_-Building-Packages-Programatically.aspx

|||

Exactly what I was looking for.

Thank you... Much Appreciated.

dynamic column headings?

Is it possible for Report Services 2000 to accomplish the following. Are there any examples available that i can take a look?

How can I turn rows in a table into column headings in a report. By the way, the user can chose one questions to see the answers for all the Test Takers.

The questions and answers are rows in two seperate tables.

For example, a certain test may have N questions and N answers. I would like to make the questions the column headings and the answers the rows. Into something like this.

Test Taker Questions 1 Questions2 Questions3 QuestionsN+1

Mike Jay Answer1 Answer2 Answer3 AnswerN+1

Jon Doe Answer1 Answer2 Answer3 AnswerN+1

etc....

Can anyone suggest a solution or documentation?

Thank you,

yadgor2000

Try using a matrix. You can easily do this in VS.Net.