Home > IT Answers > Development > How I can automated process load xml file to SQL server 2008?
Ana63
35 pts.
 How I can automated process load xml file to SQL server 2008?
Automation, SQL Server, SQL Server 2008, XML File Creation
Hello!

Software/Hardware used:
SQL Server 2008
ASKED: February 28, 2011  8:28 PM
UPDATED: March 3, 2011  1:30 PM
RELATED QUESTIONS
Answer Wiki:
You can use SSIS to create a package, save it to the server and then schedule it to run via SQL Agent. This would allow it to automatically kick off on a timedate schedule.
Last Wiki Answer Submitted:  March 2, 2011  11:18 pm  by  Hlx   690 pts.
All Answer Wiki Contributors:  Hlx   690 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

I am not sure, but u can use Business Intelligence Development Studio for that purpose !

Subhendu Sen
 22,035 pts.
 

Well, I use Business Intelligence Development Studio, but I need automated this process.

Ana63
 35 pts.
 

I have xml file every week with different extentions. What control I have to use for look current file?

Ana63
 35 pts.