we have a table that after being loaded we bulk copy it to a as400 table and then truncate the sql server table.. lets say the 400 shuts down my transaction pile ups so iam thinking lets put the transaction in a temp table and then roll another job every 10 minute to check on the as400 if it exist if it dosent then insert the record is there a way to pass a query to the as400 from sql or to conect on a as400 and query the databseHIllcat
Does your As400 server switch off alot , do you know which times this server is availiable..if yes then i would suggest you create and shedule a job to transfer the sql data to the as400 table(s) during the uptime period by using DTS.
Showing posts with label bulk. Show all posts
Showing posts with label bulk. Show all posts
Subscribe to:
Posts (Atom)