March 5, 2003 at 9:41 pm
I have a DTS package that pulls data from an AS400 file and transforms the data into an SQL Server 7 database. My initial SELECT query from the source file selects all records in the table. What I would like to do is update the AS400 table and flag the records that I have already retrieved so I don't have to pull them again. Is it possible to also run an update once the transformation completed successfully?
Nerds are cool
Edited by - dipetersen on 03/05/2003 9:42:16 PM
David Petersen
dipetersen.com
March 6, 2003 at 3:43 pm
Since no one else has taken a stab at this I will....
I'm sure that you could build some flag in the AS400 DB System to flag the records prior to exporting to text file however, if you are not bringing down a lot of data, then you might want to export it all nightly and code you SQL / DTS package to ensure that you are not importing the same records twice.
Not sure what you mean about the update following the transformation but if you are talking about running a SQL update following the transformation of the AS400 export into SQL then the answer would most likely be "Yes" however more details would be necessary.
Hope this helps.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 6, 2003 at 5:08 pm
I guess that I wasn't very clear in my description of the problem but you figured it out! 🙂
I guess my main question is:
Is it possible to update the source table on an AS/400 table via ODBC connection after I export the data to an SQL server so the next time the DTS package runs, we only pull new records. We currently have it scheduled to run every hour.
I believe your answer was "yes" and I thank you for that. Now the trick is figuring out if I have authority to update the AS/400 data!
thank you again.
David P
David Petersen
dipetersen.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply