Im trying to do the upload through a flat file source and OLE DB destination. OLE DB destination is giving the error on the incorrect name

Invalid object name in the destination. Trying to load each file from the directory and it's corresponding table in the DB

Thanks for the reply! This does work, but the problem that I have with this is that Triggers are sort of hidden and I would like to centralize all of...

I agree...I am currently studying for this exam as well with the same book and XML is the toughest chapter to grasp for me, and I usually pick things...