June 3, 2007 at 3:37 am
Hello guys!
I have created two DTS packages:
- One from Windev Databases to SQL Server 2000 Databases named DTS 1
- The 2nd one from SQL Server 2000 to Oracle 9i Databases named DTS 2
The scenario is that, users are updating tables from Windev databases. After the update i want the DTS 1 and DTS 2 packages to be executed every 10 minutes so that it can apply the update to SQL Server then Oracle databases.
Both the DTS packages have been successfully created but i don't know how to plan it so that it execute every 10 minutes.
Thanks for your reply and have a good day!
Aboubakar Alhadji Ibrahim
June 3, 2007 at 5:24 pm
create job in SQLAGENT which will execute DTS1 & 2 every 10 minute. i hope this helps
June 3, 2007 at 10:55 pm
In SQL Server Agent create a new job. In that job create 2 steps - one for each of the packages. The job steps will both be type "Operating System Command" and will run a command something like
DTSRun /E /S myserver /N"Name of DTS Package"
where myserver is the name of the SQL Server instance that you saved the DTS packages to. The double quotes around the name are intentional - they are needed because the typical name of a DTS package includes spaces etc.
June 4, 2007 at 2:35 am
Thank you for the posts!
I created the jobs but whenever the DTS packages execute, my data in SQL Server and Oracle 9i are duplicating.
The example:
In windev i have :
Stu_id Name
1 Robert
2 Henri
When the DTS packages run for the first time, everything is ok
After an update in Windev let's say we add a student with an id 3 and the name Joseph:
Stud_id Name
1 Robert
2 Henri
3 Joseph
When the DTS packages execute i am getting two sets of data in SQL and Oracle servers. Actually it appears like this:
stud_id Name
1 Robert
2 Henri
1 Robert
2 Henri
3 Joseph
Can u guys help me to fix this issue, so that only the update values appear in SQL SERVER and ORACLE.
Thankz and good day to all!
Aboubakar Alhadji Ibrahim
June 4, 2007 at 8:44 am
Either add a task to each package that will truncate the destination tables before importing the data - in essence reloading the tables every 10 minutes -or add tasks that only add new data. I'm assuming your tables don't have primary keys that would prevent the addition of duplicate data.
See this thread for ideas on how to code the update/inserts: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=369179
Greg
Greg
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply