XML source control not displaying the XML file parent node columns even though it is showing in the XSD file. Is there any solution to get the XML parent nodes columns in the XML source component.
Foreach loop container control not stopping. it still executes if more than two files in the folder. all the files are in the folder. Inside the foreach loop, script task control to get the file and folder names and Execute sql task to insert the XML file(s) into sql server.Last control again script task to delete the executed file. Outside the foreach loop, another script task to delete the folders. But after deleting the folders for loop still running. not showing the green tick sign for the delete folder script task. it continues for a while.