RE: SQLUpdates

#1

The Data Driven Query is the way to go. BOL contains detailed examples.

"Ken" wrote:

Quote:

I've used DTS Transform Data tasks (with ActiveX Sctipts) to insert records
into SQLServer database tables.

1) But, I'm not clear on the best way to apply updates to existing records.
Is there a general approach I should follow, e.g., is this something that can
only be done with a Data Driven Query?

2) What if I wanted to effect an update to A SQLServer database table by
first deleting a record and then inserting a replacement. How would I
coordinate the SQL task with a Transform Data Task?

Thanks for your help.

Ken

#2

The Data Driven Query Task is one way to go but remember this will operate
on a Row * Row basis which in the case of large datasets is going to be
slow. You can of course do this using SET based processing.

If you can identify new, updated, deleted rows then you can simply use
INSERT, UPDATE, DELETE statements filtering on the correct criteria.

--
--

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

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

Quote:

The Data Driven Query is the way to go. BOL contains detailed examples.

"Ken" wrote:

I've used DTS Transform Data tasks (with ActiveX Sctipts) to insert
records
into SQLServer database tables.

1) But, I'm not clear on the best way to apply updates to existing
records.
Is there a general approach I should follow, e.g., is this something
that can
only be done with a Data Driven Query?

2) What if I wanted to effect an update to A SQLServer database table by
first deleting a record and then inserting a replacement. How would I
coordinate the SQL task with a Transform Data Task?

Thanks for your help.

Ken

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

RE: SQLUpdates

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

RE: SQLUpdates - 08-06-2004 , 08:27 PM

Re: SQLUpdates - 08-07-2004 , 03:09 AM