I need to know if i can update a external source (AS400)using SQL Servers DTS.. I well aware you can do a straight update but what i need to do is update a field in the AS400 based on filter criteria in my Data warehouse..
Is the AS400 running a different database platform? I hear them mentioned once in a while but I must admit I have never worked with one, or any type of mainframe system.
If all else fails, you could export your table, put it in SQL, do your update, then export again and load to the AS400. I would imagine it's possible to set up a connection though.
Good Luck,
Alex
A wise man once said
"The only thing normal about database guys is their tables".
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.