SQL Server Performance Forum – Threads Archive
DTS and C# codingHi, I have the following problem at hand. I need to poll a directory for arrival of xmml files.
If an xml file has arrived,
then I need to port the xml contents to a SQL Server database and delete the xml file. For this, is it advantageous to use a DTS package?
I understand that XML data can be imported to database easily.
But how am I to do polling for the file arrival? Can I do C# coding in a DTS package to acheive the same?
Any help on this topic is greatly appreciated. Thanks,
You either need to code a process that checks for the existance of files (set to run as a service) or you can schedule a job using the SQL Server Agent to periodically import files.