DTS using certain criteria - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

DTS using certain criteria

Author

Topic

sqllearner
Aged Yak Warrior

639 Posts

Posted - 2004-06-17 : 01:08:13

Emp_Details:

ref_id emp_id Class1 Class2 Address
756 23456 Level1 Stage1 erteryey
456 65789 Level1 fghghjgj
789 76542 Stage6 tyutyutu

tracking_Details:

Inc_id emp_id ref_id Dept start_date
1 23456 756 PT 12/6/04
2 65789 456 SC 23/6/04
3 76542 789 PT 11/5/04

I have 2 tables one table is the emp_details table and the other is the tracking table.Now emp_details table has the data inside.I have to transfer certain details to the tracking_details.These are the constraints

1. corressponding emp_id and ref_id should be transfered
2. the record is pulled is like if there is data in Class1 and
Class2 OR if there is only data in class2 then "Dept" in
tracking_details should be "PT".
3. If there is data only in Class1 then "Dept" in
tracking_details should be "SC"
4. Start_date is the todays date

please show me how to tackle this problem using DTS

timmy
Master Smack Fu Yak Hacker

1242 Posts

Posted - 2004-06-17 : 01:25:10

See

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=36371

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources