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

[rmsterling1972]

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.

 

[anky007]

hi , I am extracting data from the view to a flat file using ssis which is pretty simple
but i am looking for a way to send a notification file in XML after the extraction is done(the notification file should contain the number of rows inserted in the flat file kind of info), the name of both .dat file and the xml file should be generated dynamically using timestamp in the name.
please help me in doing this