ssis 2008 package : Update table on two destinations from the source

Hi All,

I need to create a package . I have one oledbsource , oledbcommand (update query) and two ole db destinations. My requirement is update table on the destination database on two different database servers. How I can achieve that. Ubdate will be in sync..

Who is Participating?
Alpesh PatelConnect With a Mentor Assistant ConsultantCommented:
Please do using Dataflow.

1. Get data from Source
2. Put data in Record Set
3. In Control flow use ForEach loop container
4. Based on you condition Set the Server name in Variable in Foreach loop. (Make sure connection should be dynamic based on variable)
5. Use Execute SQL to update row in Foreach loop.


Saroj13Author Commented:
thanks. i am new to ssis..
currently, i am using oledbsource , oledbcommand to update the data of table on the ole db destination. now i need to do the same on two other database servers... i am not sure how i can achieve this with for each loop. is it possible that you can send me the sample example

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.