Home Forums Programming XML Importing the OFAC SDN list via XML RE: Importing the OFAC SDN list via XML

  • Hi Pablo..

    I have application that requires importing SDN list and keeping it up-to-date. If a new name is added it should be inserted into tables and if any name is removed from the list, it should be marked "inactive" but should still be kept in the database.

    I created SSIS package that downloads XML file from FTP site and wrote stored procs to process the files into SQL Tables.

    If you have the requirements and would like to share with me let me know... I can do it for you...

    Divyesh