Question about DTS's

[fattyfatpants]

I have never ever even thought about using DTS but I think I need to now and really have no idea about the specifics. Here is my problem: We are using ADP for our payroll system (SQLBase 7.5) and I need to import the payroll information into one of our SQL Servers (SQL 2000) so that I can write reports on it. Is DTS the way to go on this or is there another way?? If so, is there a way to tell it to only import the newly added data instead of everything every time this is executed?? Thanks for your help.

 

[mrdenny]

Yes, DTS is the way to go.

First thing that you will need to do is install the SQLBase 7.5 drivers on the SQL Server and on the machine you will be using to develope the DTS package. Then you will need to setup your queries to get the data. There is probably a data added field of some sort on the ADP database that you can use to only pull over the previous days data.

Denny

--Anything is possible. All it takes is a little research. (Me)