Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I am using Microsoft Business Intelligence Development Studio (BIDS) to create an SSIS package. Take into account that is my first attempt with SSIS.

I want to take data from a Source database elaborate them and put in a Destination database. In the elaboration task I need also data from the Destination database.

In the Data Flow I have two "objects" a Source and a Destination. In the Source I created a query that takes data from the Source database.

Then I added a Script Component between the two.

The problems that I encounter are two:

1) How can I call from my script the
result of the query?

2) How can I also get the data from
the destination (it allows me to
connect up to 1 arrow to the script)

3) How can I write the elaborated data in the destination?

I hope you can help me, because I am quite lost.

share|improve this question

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.