Multiple Source Connections

#1

I've got a package that imports records from Access to SQL Server. I want
just new records. Here's the source from the Transform:

select * from Products where Code > '10357'

I want the code to come from the Destination table, ie.
select * from Products where Code > (Select MAX(Code) from [dbo].[Products])

How do I do this?

Thanks,
Chris

#2

Thanks,
I'm using 2000 and method 2 worked great.

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Quote:

OK So you want to take records from the Access table to SQL Server only
whee
the records in the Access table have a > Code than those already in SQL
Server.

2 methods

1. Linked server and use that in your SourceSQLStatement
2. In 2000 use an ExecuteSQL task and assign to it the value of Select
MAX(Code) from [dbo].[Products]) executed on the SQL Server connection.
Now
in the SourceSQLStatemen you can assign that to the records from Access

SELECT <field list> FROM Table WHERE Code > ?

(? being the parameter that will be substituted at runtime)

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

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

Multiple Source Connections

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

Multiple Source Connections - 07-06-2003 , 12:54 AM

Re: Multiple Source Connections - 07-06-2003 , 02:23 PM