May 5, 2009 at 3:27 am
Hi,
I used Execute sql task which will return result set as xml.after that, i get the xml into script task and i will modify thevalues in xml.
my doubt is how can i get the the xml contant as out put parameter and how can i insert into destination table by using SSIS??
May 5, 2009 at 4:30 am
What is the purpose of using XML here? Are you planning to insert the data, including the XML tags, into the table? Please explain a little more what the requirement is.
May 5, 2009 at 6:10 am
Hi, thanks for reply..
yes. i m going to insert value from one table(Source_Table) to another table(Destination_Table)
step 1: i will get Source_Table in xml format. i will send that to Script Task.
in that i will manipulate the xml content regarding for lookup check by XQuery.i made this for generic purpose
once i update the xml the stored procedure return the updated xml into the script task.
Doubt:
how can i insert that updated xml file into the destination.
May 5, 2009 at 6:16 am
Your requirement is still puzzling me. You want to create a single XML file and store that in a single BLOB field?
May 5, 2009 at 7:04 am
hi plz see the attachment
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy