Bring Data into SQL Server

[Mike]

I have the following tables on a non-SQL database that I can access
via ODBC:

Updated
OrderHeader
OrderDetails
InvoiceHeader
InvoiceDetails

When an order or an invoice is added/updated a record with the order
number is added to the Updated table. I need to loop through the
Updated table and for each record bring the data over to the
corresponding tables on the SQL server.

Does anyone have any ideas how to do this? I was attempting to do this
with a DTS job, but I don't know how to pass the order number to each
update and then loop and get the next order.

Any help would be appriciated. Let me know if you need any more
information.

Thanks,
Mike

[Allan Mitchell]

You have also posted this individually to the .dts NG. please see my answer
there.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know
"Mike" <mb****@yahoo.com> wrote in message
news:97**************************@posting.google.c om...

I have the following tables on a non-SQL database that I can access
via ODBC:

Updated
OrderHeader
OrderDetails
InvoiceHeader
InvoiceDetails

When an order or an invoice is added/updated a record with the order
number is added to the Updated table. I need to loop through the
Updated table and for each record bring the data over to the
corresponding tables on the SQL server.

Does anyone have any ideas how to do this? I was attempting to do this
with a DTS job, but I don't know how to pass the order number to each
update and then loop and get the next order.

Any help would be appriciated. Let me know if you need any more
information.

Thanks,
Mike