thanks matt.

i was just reading up on the xml.nodes and xml.value methods and think this should work fine. i've revised my import script so i first load the xml file...

thanks matt, but i don't think this will work. i need to read specific nodes in the xml structure and insert to particular columns in my tables. the method you...

thanks christopher. worked like a charm.

yes, you're right. i was missing this:

SECURITYMODE=SQL

first time reading through the documentation on how to do this i misunderstood the sapwd flag to pass in the SA password PLUS set...