How to update a second table in a tranformation?

#1

Hi

I do a transformation form access to SQL server.
for a field i do a lookup and i want to store the result also in
another table.

How can i do that in the transformation script?

Peter

#2

Use a lookup

How to Use Lookups in DTS
(http://www.sqldts.com/default.aspx?277)

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Peter van der Veen" <pvdveenRemoveThis (AT) no (DOT) spam.ming.vanbrug.nl> wrote in
message news:f3mqvvs5bf71ck7foq4oiqidgutrcmtgj7 (AT) 4ax (DOT) com...

Quote:

Hi

I do a transformation form access to SQL server.
for a field i do a lookup and i want to store the result also in
another table.

How can i do that in the transformation script?

Peter

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

How to update a second table in a tranformation?

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

How to update a second table in a tranformation? - 01-08-2004 , 08:21 AM

Re: How to update a second table in a tranformation? - 01-08-2004 , 08:30 AM