sql server dts: Transforming from one to two Tables -- sql server dts

Transforming from one to two Tables

Rafael Veronezi
8/27/2003 1:50:27 PM

sql server dts:

I have a table in a mdb file, that have a table, that will split in two
tables in a SQL Server database...
Like that...

In the mdb file, I have the table with clients regs, that have 4 booleans
fields that indicate wich categories that the client belongs... Cause the
categories are fixed in this case...

In the SQL Server, that holds a database of a similar system, but with
dynamic categories, I have 3 tables:
- Clients Table
- Categories Table
- Clients x Categories, to join Clients with Categs...

Now I need to take the data in the mdb table, and split acrros the two first
tables (because I had already created the categories in the table)... But I
can't with a simple transformation task!
Does anybody knows how can I do that with the DTS?
Thanks,
Rafael Veronezi

Re: Transforming from one to two Tables

Allan Mitchell
8/28/2003 7:08:25 AM

Two datapump tasks.

Use a WHERE clause in each to filter the data accordingley

--

----------------------------
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

[quoted text, click to view]