Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Using an Object Variable inside xml source

Using an Object Variable inside xml source

Using an Object Variable inside xml source

Good morning, guys.

Can you help me with a doubt ?

I use a "XML Source Task", passing a link in XML Location. This link is the return of a query created in "Execute Sql task".

When i use "Execute Sql task" I set the ResultSet as a single row, save the Result into a variable and use this variable (the link) in the XML Source.

Now the scenario changed and I have 21 rows in my Resultset and i need to do the same thing with "XML Source Task". For each row, i need to call XML Source, passing the result (which is the link) as a variable.

I Changed my variable from String to Object, changed my ResultSet to "Full Resul set" and the Reusult is going to the variable.

My problem began when I tried to configure my new object variable in the xml source. It didn't appear.

My options are:
1) Set 21 variables (one for each row/link) and use each one in the "XML Source Task", in a hard code mode.

2) I tried to concatenate all the rows in just one, but didn't got success.
I don't know if this is the correct way.

I know that I have to use "foreach loop container" to do this, but don't know how. I appreciate if you guys can help me using this task too.

Best regards.

RE: Using an Object Variable inside xml source

Hey guys.

Well, now the business analyst is saying that the codes won't change dinamically. So I can use hard code in my project.

Actually, i finished the development.

I did it with 2 JOBs. One for populating a staging table and the other to insert from the staging to the destiny table.

Below, is the Controw Flow from JOB1:

Below, is the Data Flow from JOB1:

Below, is the DataFlow from JOB2:

Thank you very much for your patience and sorry for my english. :)


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close