Subject : SQL Server 2005 SSIS Script Help - XML Secure Pull in to DB table
I was wondering if any of you could help me with something.....
I want to design a SSIS script that will pull XML data from a secure HTTP
website direct in to a local database table.
I have had no training on SQL Server 2005 SSIS. I have a reasonable
knowledge of SQL Server 2000 DTS but I believe this had no direct XML
integration. I have been told SSIS does have this functionality. I have tried
obvious ways of doing this using the controls available but cannot get it to
Do any of you have any example SSIS packages you could send me that does
this? OR if you don't have this could you tell me the steps I might need to
take (mentioning controls I need).
Are there any VISUAL tutorials that help with this (NOT written ones)?
Look forward to your replies.