Thanks Chris for your time and help in providing detail steps!!!

Hi Chris,  I think your approach will work for me...being a newbie, could you provide more detail steps for the dts packages and script to copy logins/fix orphans

Wow, thanks for the detail information...that helps a lot!!!

I did assign the User the role of Server Administrator, but our vendor software application received errors afterwards; as that was the only recent change made.  After removing the role,...

Thanks for the help, one more question..

Everytime this statement is run, the target text file is replaced, I was hoping to append to this target text file; is there an...

Thanks Mike,

Your suggestions was just what I needed...thanks for your help...

Regarding to do something on Error, how would you code the process to write the error information into a txt...

I found that anytime you update/delete records on the AS400, the file needs to be journaled.

Thanks, unchecking the 'row blocking' worked.

Thanks for the feedback, this looks like the way I will go....can you provide a quick sample of doing the join in a stored proc...also how to create the proc...

The CTL-P only printed the select statement, not the results.

How do you "pipe" to a .csv file?

Thanks for the feedback, I will check the ping next time when the error happens.