DTS Package with if/then Logic

#1

I would like to create a DTS package that will accomplish the following:

Check if a database table A has records.
If Yes go Else Stop.
Erase Replica table B.
Copy Database table A to replica table B.

I'm able to copy all records from one table to another automatically. I
would like some logic to check if Table A has records before deleting the
replica for copying. Is there anyway to do this? When Table A is blank if
deletes all records in Table B and then copies 0 records.

Any DTS logic help would be great.

#2

Then you need workflow.

We have examples here

Multiple Paths in Workflow
(http://www.sqldts.com/default.aspx?218)

"BSK" <bsk (AT) discussions (DOT) microsoft.com> wrote

Quote:

I would like to create a DTS package that will accomplish the following:

Check if a database table A has records.
If Yes go Else Stop.
Erase Replica table B.
Copy Database table A to replica table B.

I'm able to copy all records from one table to another automatically. I
would like some logic to check if Table A has records before deleting the
replica for copying. Is there anyway to do this? When Table A is blank if
deletes all records in Table B and then copies 0 records.

Any DTS logic help would be great.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

DTS Package with if/then Logic

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

DTS Package with if/then Logic - 05-24-2005 , 03:58 PM

Re: DTS Package with if/then Logic - 05-24-2005 , 04:10 PM