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

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • rmsterling
    New Member
    • Jul 2007
    • 4

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

    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.
  • don007
    New Member
    • Aug 2007
    • 2

    #2
    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.....apprec iate it.you can mail me at gsmehta24@yahoo .com


    thank you

    Comment

    Working...