Connecting Tech Pros Worldwide Forums | Help | Site Map

SQL Server 2005 SSIS Script Help - XML Secure Pull in to DB table

Newbie
 
Join Date: Jul 2007
Posts: 4
#1: Jul 9 '07
All,

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
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.

Newbie
 
Join Date: Aug 2007
Posts: 2
#2: Aug 16 '07

re: SQL Server 2005 SSIS Script Help - XML Secure Pull in to DB table


Hi
I am struggling with the same issue for getting xml date with secure http connection with SSIS.please let me know if u find any solution of that. plz reply me as soon asap.....appreciate it.you can mail me at gsmehta24@yahoo.com


thank you
Reply