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 |
|
MichelleMabbs
Starting Member
24 Posts |
 Posted - 2014-03-19 : 06:20:17
|
| Hi there, totally new to SSIS and have requested training however in the meantime i would like some advice on how to approach the following:I need to collect & process on average about ten new xml files on a webserver. I can use SSRS to process one of those but that is it:so i have considered SSISWe already have a secure page written in ASP.NET that collects (using VB) each XML file and displays it in a tableSo i guess i have the following optionsA) Use SSIS to download the table from the ASP.NET webpageB) Use SSRS to display each XML file? although i dont think it can process multi xml files -?C) Use the VB in the ASP.NET in SSRS - ? no idea how to do this D) Use SSIS to collect each XML file & collect in a SQL table.How feasable are all of the above? if someone can give me a useable soloution i would be most gratefulKind RegardsMichelle Michelle |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-04-07 : 15:38:18
|
| Not sure what you're end result is. Do you want to store the files in a database? Go with option "A". |
 |
|
|
|
|
|
Advice sought