Re: DTS using a parameter

#1

One option is to do this using T-SQL and the EXISTS option
to insert only new records. You can find examples and
documentation on using Exists in books online.

-Sue

On Mon, 18 Aug 2003 17:05:02 -0400, "Amit Sinha"
<amit (AT) datasyncsolns (DOT) com> wrote:

Quote:

I want to import a records from a table (Say T1) in DB2 DB to a table in SQL
DB (say T2). This will be run daily. I want only the new records coming in.
How can I do this. Is there a way to pass a parameter in the DTS?

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

Re: DTS using a parameter

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

Re: DTS using a parameter - 08-18-2003 , 10:27 PM