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.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
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?
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
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