July 25, 2011 at 2:48 pm
Hi,
I am working on creating an SSIS package that will import data from a CSV into a database table. Then use a script task to look through each record in that table, build an XML statement from it and submit that XML to a web service.
I have that data import working, and I am able to use the script task to submit hard coded XML to the web service but I am unsure of how to connect to the table from my script task to loop through the records....
How would I do this?
July 25, 2011 at 2:56 pm
This should help with that
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 25, 2011 at 2:59 pm
You'd populate a recordset. This seems to be a good descriptino of how to acces it in a script task.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply