Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rmsterling
Starting Member
2 Posts |
 Posted - 2007-07-09 : 07:09:24
|
| All,Subject : SQL Server 2005 SSIS Script Help - XML Secure Pull in to DB tableI 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 work.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.Many thanks,Regards,Richard. |
|
|
|
|
|
SQL Server 2005 SSIS Script Help - XML Secure Pull